User guide

Managing Index Partitions16-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

Click on Graph to see the results in graphical form.