Hello, As part of a rare database "maintenance"... Does VACUUM, in essence, implies whatever actions REINDEX would do? Would REINDEX before VACUUM make any more sense?
And what about ANALYZE? Would it be wise or useless, to run it after VACUUM? So... Would "VACUUM; REINDEX; ANALYZE;" make any sense as a polishing step on a heavily modified database which will then become an archived mostly read-only body? ⏤ Olivier _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users