HP Integrity NonStop H-Series User Manual
Page 222
Managing
Index
Partitions
15-4
Figure 15-2. Manual Design Window.
To redesign the table partitions manually
1.
Specify the new number of partitions wanted in the Number of
Partitions field.
2.
Specify the new sample rate in the Sample Rate field.
3.
Specify the new primary-key values in the Primary-Key pane. The New
Row button allows you to add more primary-key values to the
partitions.
4.
Click on Recompute to calculate and display the new number of rows
and percentages in each partition. The time required to complete
automatic partition design depends on the size of the table and the
sample rate. A message box is displayed.
5.
Click on Get Results to see the results in tabular form
or
Click on Graph to see the results in graphical form, as displayed in
Figure 15-3.
Note: You may switch to Auto Design mode at any time by clicking on the
Auto Design button. In this mode, you specify the number of partitions