Hi fellow-sqliters,
please forgive my newbie question, I hope it wasn't asked similar recently. I
didn't find a way to properly search the list archives to check.
CREATE TABLE demo (
id INTEGER PRIMARY KEY
);
EXPLAIN QUERY PLAN SELECT * FROM demo WHERE 0 OR id=3;
EXPLAIN QUERY PLAN SELECT * FROM demo WHERE id=3;
doesn't use the index in case 1, only in the 2nd case.
Is there a way to hint the query analyzer to use the index? What other tricks
come into your mind?
Cheers,
Marcus
P.S.: my complete use case is this
https://github.com/mro/librdf.sqlite/issues/11
