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 » Application profiling tutorials » Tutorial: Diagnosing table fragmentation

 

Identifying and fixing table fragmentation using SQL

You can also identify and fix table fragmentation using SQL.

 ♦  To check for table fragmentation
  1. In the left pane of Sybase Central, click app_profiling - DBA, and then choose File » Open Interactive SQL.

    Interactive SQL starts and connects to the app_profiling.db database.

  2. In Interactive SQL, run the following SQL statements to test for table fragmentation on the Employees table:

    CALL sa_table_fragmentation( 'Employees' );

    If the value in the segs_per_row (the number of segments per row) column is greater than 1.1, then table fragmentation is present. Higher degrees of fragmentation may negatively impact performance.

  3. In Interactive SQL, run a REORGANIZE TABLE statement similar to the following to reduce table fragmentation:

    REORGANIZE TABLE Employees;
  4. You have completed the tutorial on diagnosing table fragmentation.

 See also