SQL/MP Query Guide

Contents
HP NonStop SQL/MP Query Guide—524488-003
vii
6. Analyzing Query Performance (continued)
6. Analyzing Query Performance (continued)
MDAM With OR and Equality Predicate on Second Key Column 6-42
MDAM with Missing First Key Column 6-43
MDAM With IN List on Key Column 6-44
MDAM With Multiple Predicate Sets, LIKE, and Missing Key Column 6-44
EXPLAIN Plan for Determining the Cost of Multiple Predicate Sets 6-46
EXPLAIN Plan for Selectivity for Range Predicates 6-47
EXPLAIN Plans for Join Queries 6-48
Parallel Execution of Hash Join 6-49
Nested Inner Join 6-51
Cross Product Join 6-53
Parallel Execution of Nested Inner Join 6-56
Parallel Execution of Forced Merged Inner Join 6-58
Key-Sequenced Merge Join 6-60
Key-Sequenced Merge Join With Executor Aggregates 6-62
Left Join Not Transformed Into an Inner Join 6-64
Left Join Transformed Into an Inner Join 6-66
EXPLAIN Plan for UNION Operation 6-68
EXPLAIN Plan for MAX Optimization 6-70
EXPLAIN Plan for Cursor UPDATE 6-72
EXPLAIN Plan for Cursor DELETE 6-73
EXPLAIN Plan for INSERT 6-74
EXPLAIN Plan for INSERT-SELECT 6-75
EXPLAIN Plan for UPDATE 6-77
EXPLAIN Plan With Date-Time Values 6-78
HOUR Date-Time Values 6-78
DAY Date-Time Values 6-79
Comparing Cost: A Scenario 6-80
First Formulation 6-80
Second Formulation 6-83
Index
Examples
Example 1-1. SELECT Statement With ORDER BY Clause 1-5
Example 1-2. SELECT Statement With Duplicate Rows 1-6
Example 1-3. SELECT Statement With DISTINCT Clause 1-6
Example 1-4. SELECT Statement With GROUP BY Clause 1-7
Example 1-5. SELECT Statement With GROUP BY Clause and SUM Function 1-8