Showing entries with tag "Index".

Found 1 entries

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