On 19 Sep 2019, at 1:14pm, Fredrik Larsen <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
