SQLite's Automatic Indexes
I was not aware that SQLite creates temporary indexes in places where other databases would perform merge joins.https://sqlite.org/tempfiles.html#transient_indicesSQLite also creates background indexes for ROWID, of which I was aware.https://sqlite.org/rowidtable.html