Adaptive Server rebuilds all affected indexes when you perform a split, merge, or move partition on a table with indexes.
Command |
Global nonclustered index |
Local index |
Local clustered index |
Local nonclustered index |
---|---|---|---|---|
split partition |
Index is rebuilt |
All affected index partitions are rebuilt |
Rebuilds all index partitions |
Rebuilt on default segment |
merge partition |
No effect if the source and destination segments are the same |
All affected index partitions are rebuilt |
Rebuilds all index partitions |
Rebuilt on default segment |
If the table you are splitting or merging includes indexes on separate segments, the segments on which the newly rebuilt indexes reside depend on the type of index.
Type of index |
After the split or merge operation |
---|---|
Global nonclustered index |
The index remains on the same segment as prior to the operation. |
Local nonclustered index |
|
Local clustered index |
|