SQLite index usage 2009-04-06 01:43pm
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]
