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

 

Viewing an object's fragmentation details

You can view fragmentation information for an object from the Fragmentation tab in Sybase Central.

Prerequisites

DBA authority.

Context and remarks

Many.

 View an object's fragmentation details (Sybase Central)
  1. Click 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.

Results

Fragmentation details for the specified object appear in the dbspace map in the bottom pane.

Next

None.