Optimize Tables

The Optimize Table Wizard should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows (tables that have VARCHAR, BLOB, or MEMO columns). Deleted records are maintained in a linked list and subsequent INSERT operations reuse old record positions. You can use optimization to reclaim the unused space and to defragment the data file.

To call the Optimize Tables Wizard select the Services | Optimize Tables menu item.

OPTIMIZE TABLE works in the following way:

if the table has deleted or split rows, repair the table;

if the index pages are not sorted, sort them;

if the statistics are not up to date (and the repair couldn't be done by sorting the index), update them.

Location

Host
Host for selecting a database.

Database
Database, containing tables for optimization.

Suppress Backups
Check this option to suppress backups.

Select Tables

Available Tables
Tables available for optimization. These are all the tables from the database you selected on the Location step.

Selected Tables
Tables selected for optimization.

To move the table from one list to another double-click it or select it (use Ctrl or Shift to select multiple tables) and click button > or <. To move all the tables click button >> or <<.

Start

This page is activated automatically on clicking the Finish button. It displays the optimization process (Operation log) and its results (Results).

See also:

Verify Tables Repair Tables