Hi, I wonder if the following optimization would be easy to do:
sqlite> create table t(a,b); sqlite> create index a on t(a); sqlite> explain query plan select a from t where a is not null; QUERY PLAN `--SCAN TABLE t USING COVERING INDEX a sqlite> explain query plan select a from t where (a is not null)=1; QUERY PLAN `--SCAN TABLE t USING COVERING INDEX a sqlite> create index b on t(b) where b is not null; sqlite> explain query plan select b from t where b is not null; QUERY PLAN `--SCAN TABLE t USING COVERING INDEX b sqlite> explain query plan select b from t where (b is not null)=1; QUERY PLAN `--SCAN TABLE t So basically, match the where of the index as part of an expression. I'm guessing the answer is no, but I thought I'd ask anyway Wout. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
