5 ms·
> it only has one index per-table source I don't know for sure what this means, but it sounds like it is incorrect.
by SQLite 8y ago
> it only has one index per-table source
I don't know for sure what this means, but it sounds like it is incorrect.
- cryptonector 8y agoI could swear I've seen you say this. Maybe I'm mis-remembering? ISTR it was that for each table source in a query SQLite3 uses just one index (or the table itself) for indexing or scanning to find relevant rows in that table source.
- SQLite 8y agoSQLite can use multiple indexes if there are OR terms in the WHERE clause. SQLite tries to only uses indexes in situations where they help the query run faster. SQLite is not limited in its use of indexes. It is just that the use of multiple indexes for a single FROM-clause term is rarely helpful.
- cryptonector 8y agoAh, OK, thanks!