Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Tips for improving performance » Fragmentation-related performance tips » Reduce table fragmentation » Methods to reduce table fragmentation

 

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