On 19 Sep 2019, at 1:14pm, Fredrik Larsen <frel...@gmail.com> wrote: > I have a aggregate query that works as expected when the ordering is > ascending, but uses a TMP B-TREE when changing order to descending, see > stackoverflow link below.
For experimental purposes, you might take a backup copy of your database and try executing ANALYZE before the query. Also try PRAGMA reverse_unordered_selects = YES before the query. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users