Mastering MySQL 4 [Electronic resources]

Ian Gilfillan

نسخه متنی -صفحه : 229/ 121
نمايش فراداده

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.