ANALYZE TABLE table_name[,table_name...]
Description: Analyzes and stores key distribution for given table or tables, the equivalent of myisamchk -a table_name. The stored key distribution is used to help optimization during joins. Returns a resultset table showing the status after running the command.
Limitations: MyISAM and BDB tables
Description in: Day 16
See also: OPTIMIZE TABLE
Get Sams Teach Yourself MySQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
