User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 16-5
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
the sampling rate and dba/m Database Manager will compute the primary
key values when you press the Recompute button.
Automatic Design
To have dba/m Database Manager automatically design index partitions
1. Specify the number of partitions in the Number of Partitions pane in the
Auto Design pane as shown in Figure 18-1.
2. Specify the sample rate.
3. Click on Auto Design. The time required to complete partition design
depends on the size of the index and the sample rate. A message box is
displayed.
4. To see the new index partitions, click on Get Results. Click on the
Graph button in the Design Partition window to view the results in
graphical form.
Display Dependencies
Before implementing a newly-designed partition in a table, you can analyze
the impact of your proposed design.
• To display the programs which depend on the index, click on
Dependent Programs. Programs which would be invalidated by
redesigning the partition are displayed.
• To display all objects, including programs, which depend on the
partitions, click on Objects. All SQL objects that depend on the
partitions are displayed.
View Partitions
Click on Index Partitions, then click on View in the Main window, to view
partitions for an existing index. The View Partition window will be
displayed, as shown in Figure 16-3.