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