Re: [sqlite] SQLite query planner doesn't seem to know when a partial index is COVERING

June 15, 2018 1:09 PM To: SQLite mailing list Subject: [sqlite] SQLite query planner doesn't seem to know when a partial index is COVERING Looks like a missed optimization opportunity here. Well, more than that - there doesn't appear to be a way to get SQLITE to automatically use a parti

[sqlite] SQLite query planner doesn't seem to know when a partial index is COVERING

Looks like a missed optimization opportunity here. Well, more than that - there doesn't appear to be a way to get SQLITE to automatically use a partial index if a similar non-partial index exists. E.g. create table Foo(a,b,c,d,e); create index Foo_inx on Foo(a,b,c); create index Foo_partial_inx