On Fri, Feb 16, 2018 at 6:07 PM, David Raymond <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

