SQL/MX 3.2 Query Guide (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Query Guide—663851-002
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 Thursday, August 2, 2012 4:47 PM