On 7 Feb 2018, at 1:31am, Mark Wagner <m...@google.com> wrote:
> Wow, I had no idea that the order of the columns in the index effects how
> they're used. Must. Study. More.
Just like a phone directory. If the order is (surname, firstname) then the
first name in the directory is the one with the lowest surname, not the lowest
firstname. This is why your covering index doesn't make sense.
sqlite-users mailing list