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

Contents
HP NonStop SQL/MX Query Guide—523728-003
v
7. Operators and Operator Groups (continued)
7. Operators and Operator Groups (continued)
SPLIT_TOP Operator 7-49
SUBSET_DELETE Operator 7-50
SUBSET_UPDATE Operator 7-51
TRANSPOSE Operator 7-52
TUPLE_FLOW Operator 7-52
TUPLELIST Operator 7-53
UNIQUE_DELETE Operator 7-53
UNIQUE_UPDATE Operator 7-55
UNPACK Operator 7-56
VALUES Operator 7-57
8. Parallelism
Types of Parallelism in 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
Plan Fragments 8-16
Degree of Parallelism 8-21
Influencing Parallel Plans 8-24
System Default Settings That Affect Parallelism 8-25
Index