SQLite's automatic indexes
If you look at SQLite's EXPLAIN output, you sometimes may notice something unusual if you're coming from other SQL databases like PostgreSQL or MySQL.
https://misfra.me/2022/sqlite-automatic-indexes/
SQLite Index
Creator
Creator
Seonglae ChoCreated
Created
2023 Jan 7 6:8Editor
Editor
Seonglae ChoEdited
Edited
2023 Jan 7 6:8Refs
Refs