OPTIMIZE

The OPTIMIZE TABLE statement is used to reduce the table space by reclaiming space occupied by deleted rows in a default table.

The general syntax is

    OPTIMIZE TABLE table_name