CODE EXAMPLE FOR SQL

sqlite ignore index

sqlite> CREATE TABLE foo(bar);
sqlite> CREATE INDEX foo_idx ON foo(bar);
sqlite> EXPLAIN QUERY PLAN SELECT * FROM foo WHERE bar = ?;
QUERY PLAN
SEARCH TABLE foo USING COVERING INDEX foo_idx (bar=?)
 
-- ignore index using NOT INDEXED                                                
sqlite> EXPLAIN QUERY PLAN SELECT * FROM foo NOT INDEXED WHERE bar = ?;
QUERY PLAN
SCAN TABLE foo