Github
Photos
GCount
Quotes
Home
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]
USING [IndexName]