SQL/MX 3.2 Query Guide (H06.25+, J06.14+)

Parallelism
HP NonStop SQL/MX Release 3.2 Query Guide—663851-002
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. EXPLAIN statement 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
.
TP663851.fm Page 18 Thursday, August 2, 2012 4:47 PM