module SQLite3::Constants::Optimize

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

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.

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.

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

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

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