Skip to main content

ANALYZE Statement

The ANALYZE statement recomputes the statistics on Goose's tables.

Usage​

The statistics recomputed by the ANALYZE statement are only used for join order optimization. It is therefore recommended to recompute these statistics for improved join orders, especially after performing large updates (inserts and/or deletes).

To recompute the statistics, run:

ANALYZE;