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 (as of MySQL 4.0.13) 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/4.1/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.
