SQLite

Query and Index Inspection

sql

EXPLAIN QUERY PLAN
SELECT *
FROM table_name
WHERE a = '1';

PRAGMA index_info('idx_search');
PRAGMA index_list('visitor');

Use EXPLAIN QUERY PLAN first when checking whether an index is being used.