In the last episode (Oct 27), wolverine my said: > Given the commands like ANALYZE, OPTIMIZE and CHECK, what is the > preference order to execute these commands?
OPTIMIZE calculates statistics as it rebuilds the table, so there's no need to run an ANALYZE pass after it. You shouldn't ever need to run a CHECK unless your OS or MySQL crashes often. in which case you should be filing bug reports :) -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]