Adding partitions – HP NonStop G-Series User Manual

Page 213

Advertising
background image

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005

15-7

Choose Base Table

Use the Base Table Catalog and Base Table panes to choose base tables.

1. In the list of catalogs shown in the Base Table Catalog field, double-

click on the catalog that contains the base table for the partition. The
tables in the catalog are displayed in the Base Table field.

2. Double-click on the table you want to use as a base table.

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 table. Click
on View to view the results. The results are shown in the Monitor Partition
window.

Adding Partitions

To add partitions to a table, click on Table Partitions in the Main window,
then click on Add. The Add Partition window will be displayed, as shown
in Figure 15-5.

Advertising