Manual design – HP NonStop G-Series User Manual

Page 231

Advertising
background image

Managing Index Partitions

16-4

Manual Design

When you click on Manual Design in the Partition Selection window, the
Manual Design window is displayed, as shown in Figure 16-2.

Figure 16-2. Manual Design Window.

To redesign the index 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 index 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.

Advertising