On Mon, 14 Oct 2002, Alexander Burbello wrote: > I make always confuse, what is the diference between the command CHECK and > ANALYZE.
Hi, ANALYZE TABLE checks through and updates the key distribution information of a table (affects join order). CHECK TABLE check the table for errors. It also updates key statistics for MyISAM tables. CHECK TABLE equals myisamchk -m [table] with MyISAM tables. All of this can be found on the manual, too. And much more, actually. Best regards, Iikka Oh by the way: SQL ****************************************** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ****************************************** --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php