ANALYZE

The ANALYZE statement recomputes the statistics on SereneDB'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:

Query

ANALYZE;