HP NonStop G-Series - Manual (Page 207)

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005 15-1
CHAPTER 15. MANAGING TABLE
PARTITIONS
A partition is a portion of the table residing on a volume different from the
volume on which the table was initially created. When creating partitions of
a table, you specify the number of partitions and the volume, catalog, and
primary-key values for each partition.
Using dba/m Database Manager table partition management windows, you
can
•
Design partitions
•
View partitions
•
Add partitions
•
Alter partitions
•
Drop partitions
•
Perform a simple move on a partition
•
Perform a one-way split on a partition
•
Perform a two-way split on a partition
Designing Table Partitions
Partition design computes the primary key values for a given distribution of
rows across partitions.
To design a table partition, click on Table Partitions in the Main window,
then click on Design. The Partition Selection window will be displayed, as
shown in Figure 15-1.