Table Statistics with ANALYZE
Advanced
The query planner chooses between plans by estimating how many rows each step touches. Those estimates come from statistics about your data. SQLite keeps them in a table called sqlite_stat1, which is created and filled by the ANALYZE command.
The orders table (5,000 rows) has two indexes: idx_orders_customer and idx_orders_status. Run ANALYZE, then return the columns tbl, idx and stat from sqlite_stat1, ordered by tbl and then idx.
Constraints
- Run
ANALYZE;first - Return
tbl,idx,statfromsqlite_stat1 - Order by
tbl, thenidx
Hints
Hint 1
ANALYZE; has no arguments for the whole database.
Hint 2
sqlite_stat1 appears only after ANALYZE has run.
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.