SQL/MX 2.x Query Guide (H06.04+, J06.03+)

Contents
HP NonStop SQL/MX Query Guide—540437-005
v
7. SQL/MX Operators (continued)
7. SQL/MX Operators (continued)
SORT_GROUPBY Operator 7-63
SORT_PARTIAL_AGGR_LEAF Operator 7-64
SORT_PARTIAL_AGGR_ROOT Operator 7-65
SORT_PARTIAL_GROUPBY_LEAF Operator 7-66
SORT_PARTIAL_GROUPBY_ROOT Operator 7-67
SORT_SCALAR_AGGR Operator 7-68
SPLIT_TOP Operator 7-69
SUBSET_DELETE Operator 7-70
SUBSET_UPDATE Operator 7-71
TRANSPOSE Operator 7-73
TUPLE_FLOW Operator 7-74
TUPLELIST Operator 7-75
UNARY_UNION Operator 7-76
UNIQUE_DELETE Operator 7-78
UNIQUE_UPDATE Operator 7-79
UNPACK Operator 7-80
VALUES Operator 7-81
8. Parallelism
Types of Parallelism in NonStop SQL/MX 8-1
Partitioned Parallelism 8-1
Pipelined Parallelism 8-2
Independent Parallelism 8-2
Parallel Execution Principles 8-2
Query Plan as a Data Flow Tree 8-2
Exchange Nodes and Plan Fragments 8-3
DAM and ESP Parallelism 8-5
Parallel Plan Generation 8-6
Scan, Update, and Delete 8-6
Join With Matching Partitions 8-6
Join With Parallel Access to the Inner Table 8-10
Unions 8-11
Group Bys 8-11
Sort 8-12
Insert and Select 8-12
Combining Different Types of Parallelism 8-12
Explaining Parallel Plans 8-12
How to Determine if You Have a Parallel Plan 8-12