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

Parallelism
HP NonStop SQL/MX Query Guide—523728-003
8-18
Plan Fragments
This output shows the sequence numbers, the operators, parallel information, and the
cardinality for the operators. Using the sequence numbers, you can create a query tree
that visually shows the query plan.
Figure 8-3. DISPLAY_EXPLAIN OPTIONS 'f' SQLQUERY Output for Sample
Query Using ESP Parallelism
LC RC OP OPERATOR DESCRIPTION CARDINALITY
-- -- -- ------------------------- -------------------- ----------
12 . 13 root 1.23E+4
11 . 12 esp_exchange 1:2(range) 1.23E+4
10 . 11 sort 1.23E+4
9 . 10 hash_groupby 1.23E+4
2 8 9 hybrid_hash_join 3.26E+4
7 . 8 esp_exchange 2(range):2(range) 1.51E+4
4 6 7 merge_join 1.51E+4
5 . 6 partition_access 7.27E+4
. . 5 index_scan ORDERX1 (s) 7.27E+4
3 . 4 partition_access 3.11E+3
. . 3 file_scan CUSTOMER (s) 3.11E+3
1 . 2 partition_access 3.24E+5
. . 1 file_scan LINEITEM (s) 3.24E+5
Note. The plans shown in Figure 8-4 through Figure 8-8 use a default setting to generate a
zig-zag tree shape rather than the default left-leaning tree. For more information on zig-zag
trees, see Section 4, Reviewing Query Execution Plans
.