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]



Note: Replies will be formatted with PHP Markdown Extra syntax.

Name: Email (Not Required):
 
Logged IP: 18.219.236.62
To prevent spam please submit by clicking the kitten: