Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Application profiling tutorials


Tutorial: Diagnosing table fragmentation

The lessons in this tutorial explain how to use either the Application Profiling Wizard or Interactive SQL to determine if your database has table fragmentation, and if necessary, how to fix table fragmentation.

Table data is stored on database pages. When data manipulation statements such as INSERT, UPDATE, and DELETE are executed against a table, rows might not be stored contiguously, or might be split between multiple pages. Even though CPU activity is high, table fragmentation can negatively impact the performance of queries that require a scan of the table.


Lesson 1: Identifying and fixing table fragmentation using the Application Profiling Wizard
Lesson 2: Identifying and fixing table fragmentation using Interactive SQL