On Tue, Mar 3, 2015 at 11:27 AM, Jan Asselman <jan.asselman at iba-benelux.com> wrote:
> - the full table scan returns rows in rowID order, which is the order in > which the rows were added to the table > You cannot rely on that (the "the order in which rows were added" part). At best it's an implementation detail. If you want to guarantee rows are in rowid order, then explicitly ORDER BY ROWID, and often this will be free indeed, but again that's an impl detail. And there's no "meaning" that the order of rowids IMHO. --DD
