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

Reply via email to