https://misfra.me/2022/sqlite-automatic-indexes/ · SQLite's optimizer creates indexes automatically to improve query performance with only nested loop joins.
