> On Apr 28, 2017, at 2:43 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > > It seems the index is used to implement "ORDER BY revs.doc_id" part. Try > "ORDER BY +revs.doc_id"
Yes! That fixed it, and the other query I was posting about too. Thanks! —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users