module SQLite3::Constants::Optimize

Constants

ANALYZE_TABLES

Run ANALYZE on tables that might benefit. On by default.

CHECK_ALL_TABLES

Check the size of all tables, not just tables that have not been recently used, to see if any have grown and shrunk significantly and hence might benefit from being re-analyzed. Off by default.

DEBUG

Debugging mode. Do not actually perform any optimizations but instead return one line of text for each optimization that would have been done. Off by default.

DEFAULT

Useful for adding a bit to the default behavior, for example

db.optimize(Optimize::DEFAULT | Optimize::CHECK_ALL_TABLES)
LIMIT_ANALYZE

When running ANALYZE, set a temporary PRAGMA analysis_limit to prevent excess run-time. On by default.