Hi, suppose I have a partial index like that:
CREATE INDEX MyIndex1 ON MyTable ( Value1 ) WHERE Value1<>0; As documented, the query planner only uses the index if the SELECT contains that exact same condition. According to .eqp with 3.12.1 the following statement indeed uses the index: SELECT Value1 FROM MyTable WHERE Value1<>0 AND Value1=7; --EQP-- 0,0,0,SEARCH TABLE MyTable USING COVERING INDEX MyIndex1 (Value1=?) Can I safely assume that this 'workaround' works with all future versions? If not, is where a better solution? Thank you, Detlef. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users