Chapter 15. managing table partitions, Designing table partitions – HP Integrity NonStop H-Series User Manual
Page 219
dba/m Database Manager V7.1 User's Guide – 540156-001
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.