Mastering MySQL 4

ANALYZE TABLE

ANALYZE TABLE table_name [,table_name...]

For MyISAM and BDB tables, this analyzes and stores the key distribution for the specified tables. It locks the table with a read lock for the operation's duration.

Категории