beautypg.com

HP Integrity NonStop H-Series User Manual

Page 247

background image

Managing Index Partitions

17-6

Figure 16-3. View Partition Window.

Choose Index

Use the Index Catalog and Index panes to choose indexes.

1.

In the list of catalogs shown in the Index Catalog field, double-click on
the catalog that contains the base index for the partition. The indexes in
the catalog are displayed in the Index field.

Double-click on the index you want to use as a index.

Assign Sample Rate

Enter the sample rate in the Sample Rate field.

Compute Row Distribution

Click on Compute. The elapsed time to compute the number of rows may
take a long time depending on the sample rate and size of the index. Click
on View to view the results.

This manual is related to the following products: