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

Reply via email to