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.