SQL/MX 3.x Query Guide (H06.22+, J06.11+)

HP NonStop SQL/MX Query Guide—640323-001
5
8. Parallelism
TUPLELIST Operator 7-76
UNARY_UNION Operator 7-77
UNIQUE_DELETE Operator 7-79
UNIQUE_UPDATE Operator 7-80
UNPACK Operator 7-81
VALUES Operator 7-82
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
Plan Fragments 8-16
Degree of Parallelism 8-21
Influencing Parallel Plans 8-24
System Default Settings That Affect Parallelism 8-25
Index