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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Monitoring and improving database performance » Improving database performance » Performance improvement tips » Reduce table fragmentation » Methods to reduce table fragmentation

 

Using the Fragmentation tab (SQL Anywhere plug-in)

You can use the Fragmentation tab to:

  • View the fragmentation of base tables and indexes on those tables.

  • Reorganize tables and indexes.

 ♦  To view an object's fragmentation details (Sybase Central)
  1. Open the Fragmentation tab:

    1. Connect to the database.

    2. In the left pane, select the database.

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

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

    • When you select a base table, the table, its extension pages, and applicable index pages appear in the dbspace map in the bottom pane.

    • When you select an index, its index pages appear in the dbspace map in the bottom pane.

    A database's Fragmentation tab.
  3. Click Checkpoint & Refresh to perform a checkpoint and see the most recent fragmentation information.

  4. View the page indexes.

    • In the dbspace map in the bottom pane, hover your cursor over a colored-vertical bar to see the first and last page indexes at that position.

    • In the dbspace map, press and hold the Ctrl key while hovering the mouse over a colored-vertical bar to see all the page indexes at that position.

 ♦  To reorganize base tables and indexes (Sybase Central)
  1. Open the Fragmentation tab.

  2. Connect to the database as a user with DBA authority.

  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 choose 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.

    See REORGANIZE TABLE statement.

 Zooming within a dbspace map