Cecil Westerhof wrote: > 2017-08-24 11:29 GMT+02:00 Clemens Ladisch <clem...@ladisch.de>: >> Cecil Westerhof wrote: >>> But when I leave the ORDER BY out in this case, the result is the same, but >>> it looks like it is a bit faster. >> >> Are you sure? How does the output of EXPLAIN QUERY PLAN look like? > > No, I am not sure. I executed both a few times in the database browser. > Both have widely varying used times. But at first glance it looked that > without ORDER BY is about 2 times faster. But it is only at first glance, > so certainly not something concrete. > > The explains.
But I asked for EXPLAIN QUERY PLAN instead. :) > I do not really see a difference. The only difference is a Noop. > I also do not see a sort. Because it reads everything from an index that already is in the correct order. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
