Home » SQLite3 main » Index (O) » SQLite3 » Constants » Optimize ▲

123456789_123456789_123456789_123456789_123456789_

Module: SQLite3::Constants::Optimize

Relationships & Source Files
Defined in:	lib/sqlite3/constants.rb

Constant Summary

ANALYZE_TABLES =

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

# File 'lib/sqlite3/constants.rb', line 180
```
0x00002
```
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.

# File 'lib/sqlite3/constants.rb', line 189
```
0x10000
```
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.

# File 'lib/sqlite3/constants.rb', line 177
```
0x00001
```
DEFAULT =
Useful for adding a bit to the default behavior, for example
```
db.optimize(Optimize::DEFAULT | Optimize::CHECK_ALL_TABLES)
```
# File 'lib/sqlite3/constants.rb', line 195
```
ANALYZE_TABLES | LIMIT_ANALYZE
```
LIMIT_ANALYZE =

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

# File 'lib/sqlite3/constants.rb', line 184
```
0x00010
```