Module: SQLite3::Constants::Optimize

Defined in:: lib/sqlite3/constants.rb

Constant Summary collapse

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.

0x00001

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

0x00002

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

0x00010

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.

0x10000

DEFAULT = Useful for adding a bit to the default behavior, for example db.optimize(Optimize::DEFAULT | Optimize::CHECK_ALL_TABLES)

ANALYZE_TABLES | LIMIT_ANALYZE