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. This
statement works with MyISAM, BDB, and InnoDB tables. For MyISAM tables,
this statement is equivalent to using myisamchk --analyze.

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.
