On Thu, Jan 12, 2017 at 1:45 AM, Richard Hipp <d...@sqlite.org> wrote: > If you omit the ORDER BY clause, then the SQL database engine (*any* > engine, not just SQLite) is free to return the rows in whatever random > order it chooses. And it does not need to explain itself when it > does. :-) >
One thing I was not expecting was SQLite to use the index at all: since the query does not apply any filter (where clause), it simply states that the user wants all the rows, and while it is true that the order is something the engine can choose, why bother traversing an index instead of a direct scan of the table? Luca _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
