SQLite index usage

To check if your SQLite query is using an index or not do:

EXPLAIN QUERY PLAN SELECT * FROM Table WHERE ID = 12;

and look for USING [IndexName]

Leave A Reply
All content licensed under the Creative Commons License