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