Reorganizing Indexes

Reorganize an index to improve performance.

1. In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
2. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables > table name and click the Name field of the table.
3. Click the arrow and select Properties.
4. Select Indexes and select the Name field of the index.
5. Click the arrow and select Reorganize.
6. Click Next.
7. Review the space utilization information to confirm that reorganization is needed.

   If space utilization is low, run reorganization.

   See Adaptive Server Enterprise 15.7 ESD #2 Performance and Tuning Series: Improving Performance with Statistical Analysis.

   Space utilization is 0 when row count is equal to 0. For derived statistics on space utilization, the row count is based on the information from systabstats.

8. Click Next.
9. Select the type and level of reorganization, then click Next.

   Option	Description	Restrictions
   Compact	—	Not supported with indexes.
   Defragmentation	—	Not supported with indexes.
   Forwarded rows	—	Not supported with indexes.
   Rebuild	Remove row forwarding and reclaim unused page space. Rewrite all rows to accord with a clustered index for a table, if it has one. Write rows to data pages to accord with any changes made in space management settings through sp_chgattribute. Drop and re-create all indexes belonging to the table.	Requires that the select into database option is set to true. Not supported with system tables. Rebuilding an index on an all-pages-locked table is not supported.
   Reclaim space	Reclaim unused page space resulting from deletions and row-shortening updates.

10. If you selected Reclaim space in the previous screen, select your reorganization options and click Next:
    • Compress – compress the rows affected by the reorganization.
    • Resume – start reorganization at the point in a table where the previous reorganization left off.
    • Time – specify the length of time allowed for running reorganization.
11. Review the Summary page and click Finish.