HP NonStop G-Series User Manual

Page 210

Advertising
background image

Managing Table 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 and

Advertising