4 ms·
The SQLite documentation explains how (and how well) this works: https://www.sqlite.org/optoverview.html#the_skip_scan_optimization https://www.sqlite.org/optov
by Cervisia 7mo ago
The SQLite documentation explains how (and how well) this works: https://www.sqlite.org/optoverview.html#the_skip_scan_optimization https://www.sqlite.org/optoverview.html#the_skip_scan_optimi...
- igorw 7mo agoWhile Postgres did introduce skip scan in 18, it only works for equality matching: https://www.crunchydata.com/blog/get-excited-about-postgres-18#b-tree-skip-scans https://www.crunchydata.com/blog/get-excited-about-postgres-...