SQL/MX 3.2.1 Query Guide (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
vi
Index
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
Examples
Example 1-1. OR Optimization DDL 1-13
Example 1-2. EXPLAIN statement OPTIONS ‘f’ Output for Query Using
CHECK_CONSTRAINT_PRUNING 1-18
Figures
Figure 1-1. EXPLAIN statement OPTIONS ‘f’ Output for Nested Join With Indexes
LX1 and LX2 From LINEITEM Table 1-11
Figure 1-2. Query Plan 1-19
Figure 4-1.
Left Linear and Zig-Zag Trees 4-13
Figure 4-2.
Visual Query Planner 4-16
Figure 5-1. Query Plan Output in Visual Tree Format 5-4
Figure 5-2. Group By Operator Not Using DAM 5-11
Figure 5-3. GROUP BY Operator at the DAM Level 5-13
Figure 5-4. Two GROUP BY Operations 5-13
Figure 5-5. Query Tree for the Forced Plan 5-15
Figure 5-6.
Logical Specification and Lower Exchange Operators 5-16
Figure 5-7.
Type2 Hash Join 5-17
Figure 8-1. Matching Partitions Join Using ESP Parallelism 8-14
TP663851.fm Page vi Wednesday, January 30, 2013 5:37 PM