You can also identify and fix table fragmentation using SQL.
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.
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.
In Interactive SQL, run a REORGANIZE TABLE statement similar to the following to reduce table fragmentation:
REORGANIZE TABLE Employees;
You have completed the tutorial on diagnosing table fragmentation.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|