N Sj wrote: > In our dbmail environment dbmail_headervalue > table has become very large and DBA is recommending running optimize table. > Then I ran into a thread in dbmail archives that if the table > dbmail_headervalue is dropped and recreated then it will get re-populated by > running "dbmail-util -by", if that is possible then should we run OPTIMIZE > TABLE or just drop and recreate the table.
Dropping, re-creating and re-populating the table is a valid procedure. However, you will end up with the same sized table. I've blogged about a better approach on blog.dbmail.eu. > > Also we run "dbmail-util- a -y -vv" every night. > > Thank you for your input. > > > > > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
