OPTIMIZE

OPTIMIZE

OPTIMIZE TABLE table_name [,table_name]...

For MyISAM tables, this sorts the index, updates the statistics, and defragments the data file.

For BDB tables, this is the same as ANALYZE TABLE.

This locks the table for the duration of the operation (which can take some time).