Diferences between check and analyze

2002-10-14 Thread Alexander Burbello
I make always confuse, what is the diference between the command CHECK and ANALYZE. Regards sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Diferences between check and analyze

2002-10-14 Thread Iikka Meriläinen
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