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]
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]