You can also identify and fix table fragmentation using SQL.
In the left pane of Sybase Central, click app_profiling - DBA, and then click File » Open Interactive SQL.
Interactive SQL starts and connects to the app_profiling.db database.
In Interactive SQL, execute the following SQL statement 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.
In Interactive SQL, execute the following REORGANIZE TABLE statement to reduce table fragmentation:
REORGANIZE TABLE Employees;
You have completed the tutorial on diagnosing table fragmentation.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|