SQL/MX 3.2.1 Query Guide (H06.26+, J06.15+)

Forcing Execution Plans
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-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
TP663851.fm Page 4 Wednesday, January 30, 2013 5:37 PM