Ned Batchelder wrote:
If you want a particular order, use an ORDER BY clause. If you don't
specify one, the order of the result set is undefined, and therefore the db
can do whatever it likes. Even if it seems predictable as observed in your
experiments, it may change when the result set gets larger, or as the db
gets older (more deletes and inserts), or as you upgrade to newer versions
of SQLite.
--Ned.
I'm using 2.8.16, and by looking at the slides of the presentation about
indexes, it is more than likely that the results are at least sorted
like the first column of the index.
Isn't that true?
Regards,
Tom,
