Reorganizing base tables and indexes

Administrators can reorganize base tables and indexes from the Fragmentation tab in Sybase Central.

Prerequisites

DBA authority.

Context and remarks

Many.

 Reorganize base tables and indexes (Sybase Central)
  1. Click the Fragmentation tab.

  2. Connect to the database.

  3. In the left pane, select the database.

  4. In the right pane, click the Fragmentation tab.

  5. Select an object from the top pane. The fragmentation information appears in a dbspace map in the bottom pane:

  6. Choose one of the following methods to reorganize the object.

    • Click Reorganize to execute a REORGANIZE TABLE statement on the selected object.

    • Drag an object from the top pane into an Interactive SQL SQL Statements pane. A REORGANIZE TABLE statement for the object appears in the SQL Statements pane. Execute the statement.

      This method is useful when you want to reorganize the objects at a later time or when you want to continue using Sybase Central while reorganizing the objects.

    • Select an object from the top pane, right-click, and click Copy to copy a REORGANIZE TABLE statement for the object into the clipboard. Then, in Interactive SQL paste the statement into SQL Statements pane and execute the statement.

      This method is useful when you want to reorganize the objects at a later time or when you want to continue using Sybase Central while reorganizing the objects.

Results

The specified table or index is reorganized.

Next

None.

 See also