#135 · SQL and analytics · 6.7 minFive Index Rules for Slow SQL, Checked in SQLite
On 200,000 made-up orders, one index turned a full scan into a search that was at least 20 times faster.
Python 3.12.152 videos tagged "sql performance".
#135 · SQL and analytics · 6.7 minOn 200,000 made-up orders, one index turned a full scan into a search that was at least 20 times faster.
Python 3.12.15
#276 · How it works, by example · 6.5 min200,000 rows: one CREATE INDEX turned a full scan into a search, same answer.
Python 3.12.15