Reorganizing Index Partitions

Reorganize an index partition 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. Click Indexes > index name > Properties > Index Partitions > index partition name and select Reorganize.
5. Click Next.
6. Review space utilization 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.

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

   Option	Description	Restrictions
   Compact	—	Not supported with index partitions.
   Defragmentation	—	Not supported with index partitions.
   Forwarded rows	—	Not supported with index partitions.
   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 partition on an all-pages-locked table is not supported.
   Reclaim space	—	Not supported with index partitions

9. Review the Summary page and click Finish.