On 9/16/18, John Found <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
