SQLite's Automatic Indexes
I was not aware that SQLite creates temporary indexes in places where other databases would perform merge joins.<p><a href="https://sqlite.org/tempfiles.html#transient_indices" rel="nofollow">https://sqlite.org/tempfiles.html#transient_indices</a><p>SQLite also creates background indexes for ROWID, of which I was aware.<p><a href="https://sqlite.org/rowidtable.html" rel="nofollow">https://sqlite.org/rowidtable.html</a>