ASA SQL User's Guide
Monitoring and Improving Performance
As you make changes to your database, the database file, tables, and indexes can become fragmented. Fragmentation can decrease performance. Adaptive Server Anywhere provides information that you can use to assess the level of fragmentation in files, tables, and indexes.
This section describes how to detect fragmentation in files, tables, and indexes, and how to defragment them.
File fragmentation
Table fragmentation
Index fragmentation
Monitoring query performance