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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to