Syntax:
ANALYZE [LOCAL | NO_WRITE_TO_BINLOG] TABLE tbl_name [, tbl_name] ...

ANALYZE TABLE analyzes and stores the key distribution for a table.
During the analysis, the table is locked with a read lock for MyISAM
and BDB. For InnoDB the table is locked with a write lock. This
statement works with MyISAM, BDB, and InnoDB tables. For MyISAM tables,
this statement is equivalent to using myisamchk --analyze.

For more information on how the analysis works withinInnoDB, see
http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html.

MySQL uses the stored key distribution to decide the order in which
tables should be joined when you perform a join on something other than
a constant.

This statement requires SELECT and INSERT privileges for the table.

URL: http://dev.mysql.com/doc/refman/5.0/en/analyze-table.html

