Hello sqlite-users, is it true, that in sqlite3 indices are not stored in the database-file?
When reading the section http://sqlite.org/lang_createindex.html it seems that CREATE INDEX statements are only stored in the sqlite_master table and the index will be generated every time the database is opened. Can sqlite3 be forced to store the index itself in the database-file? (In SQLite2 indices were stored directly in the file, wheren't they?) When creating an index on a database the filesize does not increase so I suppose the index is not stored in the file. Background: 1. The database will be used "read-only", a regeneration of the index is not necessary. 2. The database will be accessed via jdbc, a regeneration of indices with every opening of the file causes to many "regeneration". TIA, Michael _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
