SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Forcing Execution Plans
HP NonStop SQL/MX Query Guide—523728-003
5-4
Reviewing the Optimized Plan
Now, view the output in a more visual tree format that shows the parent and child
relationships. The sequence numbers and table names are also shown in Figure 5-1.
You need to understand the relationships and which operations occur in the left and
right hand sides of the operator tree before you can translate the operator tree into a
text format that can be used to force the execution plan.
An easier way to see the operator tree for a query is to use the Visual Query Planner
application. The Visual Query Planner provides the query execution plan in a graphical
form so that you can easily see the operator tree.
Figure 5-1. Query Plan Output in Visual Tree Format
ROOT 9
HYBRID_HASH_JOIN 8
HYBRID_HASH_JOIN 7
PARTITION_ACCESS 2
PARTITION_ACCESS 6 PARTITION_ACCESS 4
FILE_SCAN_UNIQUE 1
DEPT
FILE_SCAN 5
EMPLOYEE
FILE_SCAN_UNIQUE 3
JOB
VST062.vsd