Reorganize table

Use the Reorganize table window to restore a table to its ideal organization. The ideal organization for a database table is for its rows to be laid out on pages, ordered by their key values in some frequently used index. You can reorganize a table by compressing out deleted records or by a selected index.

To view the command used to perform this action, click Show Command.

For more information, see the following:

Reorganize the table

Table partition

Allow reorganization to be suspended

Allow users to access the table during reorganization (Online)

Access paths

Number of tasks