SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-291
Considerations for MODIFY
Offline Partition Management for Range Partitions
MODIFY supports these offline partition management operations for range partitions:
•
Adding a new empty partition.
•
Dropping an existing empty partition.
•
Moving an existing partition to a new location.
•
Splitting an existing partition and then moving the first or last part of the data to a
new partition.
•
Splitting an existing partition and then merging the first or last part of the data to an
existing adjacent partition.
•
Merging two adjacent partitions into one.
•
Reusing an existing partition by setting the FIRST KEY values of the partition to
new values. You can optionally remove existing data in the partition to be reused.
Offline Partition Management for Hash Partitions
MODIFY supports these offline partition management operations for hash partitions:
•
Adding a new hash partition and rebalancing data (that is, redistributing existing
data to all partitions, including the new partition)
•
Dropping an existing hash partition and rebalancing data
•
Moving an existing hash partition to a new location
Offline Partition Management for System-Clustered
Partitions
MODIFY supports moving an entire system-clustered partition to a new location.
Offline Partition Management for Sequence Generators
MODIFY supports moving a sequence generator to a new location.
Renaming Guardian Locations of Partitions of Tables,
Indexes or Sequence Generators
You can use the rename option to rename Guardian locations of partitions of a table,
index or a sequence generator. The following are the prerequisites for a successful
rename:
•
The table, index, or sequence generator and all the partitions must be available.