optimize

Runs database optimization tasks.

This pragma instructs the query planner to gather statistics and perform other optimizations to improve the performance of future queries. By default, it runs all available optimization tasks. An optional mask can be provided to run a specific subset of tasks.

The available optimizations are:

• 0x00001 - ANALYZE: Gathers statistics on tables and indices. This is equivalent to running the ANALYZE command. It helps the query planner make better choices.

• 0x00002 - SORT_NDX: Reorganizes b-tree pages in indices to make access more efficient, similar to a REINDEX operation. This is useful after many DELETEs or UPDATEs.

• 0x00004 - PAGES: Reorganizes b-tree pages in tables. This may help improve data locality and reduce query times.

The pragma returns a cursor with a single column containing a human-readable log of the optimizations that were performed. If the database is busy, some optimizations might be skipped.

Parameters

See also