Hi, In this page in the docs: https://sqlite.org/queryplanner.html#searching
it says: "The rows are logically stored in order of increasing rowid" Would this imply that executing a SELECT would always return the rows in order or increasing rowid? So that a "SELECT * from MyTable" would return all the rows in ROWID order because that is how they are stored. Thanks Tom _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users