Use this procedure to identify index fragmentation and to learn where to look for index fragmentation warnings. It is recommended that you periodically check for fragmentation warnings on your production database.
The statements you executed in the previous procedure introduced index fragmentation. However, on some systems there might not be enough fragmentation to result in the warnings and recommendations described in this procedure.
In Sybase Central, choose Mode » Application Profiling.
If the Application Profiling Wizard does not appear, choose Application Profiling » Open Application Profiling Wizard.
On the Welcome page, click Next.
On the Profiling Options page, select Overall Database Performance Based On The Database Schema, and then click Next.
On the Analysis File page, in the Save The Analysis To The Following File field, type C:\AppProfilingTutorial.
Click Finish.
A list of recommendations appear in the Application Profiling Details pane.
To view more detail, double-click the Fragmented Indexes. A Recommendation window appears containing a SQL statement you can run to resolve the index fragmentation.
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |