Reorganize an index partition to improve performance.
Prerequisites
You must be a system administrator, or have reorg any
table permissions when granular permissions is enabled.
Task
Reorganization is not available for all-pages-locked tables.
In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
User Tables
System Tables
Temporary Tables
Proxy Tables
Click the Name field of the table, then click the drop-down arrow and select
Properties.
In the left pane, click Indexes.
Click the Name field of the index, then click the drop-down arrow and select
Properties.
In the left pane, click Index Partitions.
Click the Name field of the index partition, then click the drop-down arrow and
select Reorganize.
On the Analysis screen, review space utilization to confirm that
reorganization is needed.
If space utilization is low, run reorganization.
See 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.
On the Commands screen, select the type and level of
reorganization.
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.