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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Tips for improving performance » Tip: Reduce fragmentation


Reorganizing base tables and indexes

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


You must be the owner of the object or have the REORGANIZE ANY OBJECT system privilege.

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, select the database. In the right pane, click the Fragmentation tab.

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

  4. Choose one of the following methods to reorganize the object:

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

    • Copy 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.


The specified table or index is reorganized.

 See also