Reorganizing Table Partitions

Reorganize a table 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. Select Partitions and select the Name field of the partition.
5. Click the arrow and select Reorganize.
6. Click Next.
7. Select the type and level of reorganization, then click Next.

   Option	Description	Restrictions
   Compact	Reclaim space and remove row forwarding.	Not supported with all-pages-locked tables.
   Defragmentation	Reorganize data and allow concurrent reads or writes.	Not supported with: Tables without an index (tables must have at least one index) System tables All-pages-locked tables
   Forwarded rows	Remove row forwarding.	Not supported with all-pages-locked tables.
   Rebuild	—	Not supported with table partitions.
   Reclaim space	Reclaim unused page space resulting from deletions and row-shortening updates.	Not supported with all-pages-locked tables.

8. Select your reorganization options, then click Next.

   Option	Description	Restrictions
   Compress	Compress the rows affected by the reorganization.	Available only when one of the following is selected: Compact Forwarded rows Reclaim space Not available on Adaptive Server versions earlier than 15.7.
   Resume	Start reorganization at the point in a table where the previous reorganization left off.	Available only when one of the following is selected: Compact Forwarded rows Reclaim space Defragmentation, and resuming reorganization on a single table partition is feasible.
   Time	Specify the length of time allowed for running reorganization.
   Skip compact extents	Specify the occupancy threshold of the extent. Adaptive Server reorganizes only the extents for which compactness falls below the occupancy threshold; extents with a compactness higher than the threshold are not reorganized. The compactness of an extent is measured as the percentage range (1 – 100) occupancy in that extent (80 is the default). Compactness = (Total space occupied in an extent / Total space in an extent) x 100.	Available only when Defragmentation is selected.

9. Review the Summary page and click Finish.