On 8/7/19, Deon Brewis <[email protected]> wrote: > If I have 2 indexes 'A' and 'B', can I use rootPage to determine which one > of them is older? > > This seems to work for me, or is it just because my database has been > vacuumed recently and if a database has a lot of empty pages it will add new > indexes to smaller pages than older indexes?
It probably only works because your DB is vacuumed. Seems to me that the rowid of the sqlite_master table entry for your index would be a more reliable indicator. Larger rowids are newer. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
