indexed by to force the query planner to use a specific index: create table tq84_tab (
id number primary key,
col text
);
explain query plan
select *
from tq84_tab
where
id = 42 and
col = 'val';
--
-- 0|0|0|SEARCH TABLE tq84_tab USING INDEX sqlite_autoindex_tq84_tab_1 (id=?)
--
create index tq84_tab_ix_col on tq84_tab (col);
explain query plan
select *
from tq84_tab
where
id = 42 and
col = 'val';
--
-- 0|0|0|SEARCH TABLE tq84_tab USING INDEX sqlite_autoindex_tq84_tab_1 (id=?)
--
explain query plan
select *
from tq84_tab INDEXED BY tq84_tab_ix_col
where
id = 42 and
col = 'val';
--
-- 0|0|0|SEARCH TABLE tq84_tab USING INDEX tq84_tab_ix_col (col=?)
--