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

Contents
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
vii
Tables
Figure 8-2. Serial Hybrid Hash Join Using DAM Parallelism 8-15
Figure 8-3. EXPLAIN statement OPTIONS 'f' SQLQUERY Output for Sample Query
Using ESP Parallelism 8-18
Figure 8-4. Query Tree With ESP Parallelism 8-19
Figure 8-5. Plan Fragment Boundary 8-19
Figure 8-6. Sample Query Plan Showing Plan Fragments 8-21
Figure 8-7. EXPLAIN statement OPTIONS 'f' SQLQUERY Output for Sample Query
Using DAM Parallelism 8-22
Figure 8-8. Query Tree for Sample Plan Using DAM Parallelism 8-23
Tables
Table 1-1. Valid Queries and Operators for OLT Optimization 1-9
Table 3-1. Histogram Temporary Tables 3-2
Table 3-2. Histogram Statistics Tables 3-3
TP663851.fm Page vii Wednesday, January 30, 2013 5:37 PM