On Jul 24, 2009, at 12:14 PM, Jon Dixon wrote: > In the description of the "Create Index" statement, it says: > > "Every time the database is opened, > all CREATE INDEX statements > are read from the sqlite_master table and used to regenerate > SQLite's internal representation of the index layout." > > Does this mean that all of the indices are regenerated when the > database is opened, or is the index stored and this is just > confirming the structure?
The latter. The index content is stored and the layout is confirmed each time the database is opened. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users