On 9/16/18, John Found <johnfo...@asm32.info> wrote: > > Is it means that in every query that uses GROUP BY and ORDER BY > simultaneously, one of the operations will always be provided by using > temporary b-tree? >
no. CREATE TABLE t1(a,b,c, PRIMARY KEY(a,b)) WITHOUT ROWID; explain query plan SELECT a, b, sum(c) FROM t1 GROUP BY a, b ORDER BY a, b; -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
