Re: [sqlite] Missing several important tricks in partial indexes

Hello, On 2018-02-27 08:27, Shevek wrote: If I create a partial index: create table a (a0, a1) create index idx on a (a0) where a1 is null; 3) The third issue is almost more major than the preceding two, and has nothing to do with covering, but with partial index selection AT ALL: If we

[sqlite] Missing several important tricks in partial indexes

If I create a partial index: create table a (a0, a1) create index idx on a (a0) where a1 is null; Then we have several issues: 1) This should be a covering index for select a0, a1 from a where a1 is null; It isn't. It's a great index, but we still defer to the table to look up the (always nu