On Fri, Feb 16, 2018 at 6:07 PM, David Raymond <david.raym...@tomtom.com>
wrote:

> Remember that the usefulness of an index depends on the ordering of the
> fields.

An index on (b, a) isn't useful if you're looking for a, it's only useful
> if you're looking for b.
>

Sometimes it is. See https://sqlite.org/optoverview.html#skipscan --DD
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to