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. Simon. _______________________________________________ sqlite-users mailing list email@example.com http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users