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