HP NonStop G-Series - Manual (Page 209)

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005 15-3
selected. User can select base partition for partonly by clicking partonly
checkbox.
Choose Partonly
To design individual partition of a table or Base partition of a table,
use Partonly option by clicking checkbox partonly. Partonly option
is only for Auto Design of a table partition.
Manual Design
To create partitions with an unequal number of rows, click on Manual
Design, as shown in Figure 15-2.
Auto Design
To create partitions with the same number of rows across all partitions
1. Enter the desired number of partitions in the Number of Partitions field
in the Auto Design pane.
2. Enter the sampling rate. The lower the sample rate number is, the more
precise the result will be, and the longer the time required for
calculation will be.
3. Click on Auto Design. The time required to complete partition design
depends on the size of the table and the sample rate. A message box
with this message is displayed.
Manual Design
When you click on Manual Design in the Partition Selection window, the
Manual Design window is displayed, as shown in Figure 15-2.