SQL/MP Query Guide

Contents
HP NonStop SQL/MP Query Guide—524488-003
ix
Examples (continued)
Examples (continued)
Example 6-29. EXPLAIN Plan for MDAM With Multiple Predicate Sets, LIKE, and
Missing Leading Key Column 6-45
Example 6-30. EXPLAIN Plan for Determining the Cost of Multiple Predicate
Sets 6-46
Example 6-31. EXPLAIN Plan for Selectivity for Range Predicates 6-48
Example 6-32. EXPLAIN Plan for Hash Join 6-49
Example 6-33. EXPLAIN Plan for Nested Inner Join 6-52
Example 6-34. EXPLAIN Plan for Cross Product Join 6-54
Example 6-35. EXPLAIN Plan for Nested Inner Join 6-56
Example 6-36. EXPLAIN Plan for Parallel Execution of Sort Merge Inner Join 6-58
Example 6-37. EXPLAIN Plan for Key-Sequenced Merge Join 6-61
Example 6-38. EXPLAIN Plan for Key-Sequenced Merge Join With Executor
Aggregates 6-63
Example 6-39. EXPLAIN Plan for Left Join Not Transformed Into an Inner Join 6-65
Example 6-40. EXPLAIN Plan for Left Join Transformed Into an Inner Join 6-67
Example 6-41. EXPLAIN Plan for UNION Operation 6-69
Example 6-42. EXPLAIN Plan for MAX Optimization 6-71
Example 6-43. EXPLAIN Plan for Cursor UPDATE 6-72
Example 6-44. EXPLAIN Plan for Cursor DELETE 6-74
Example 6-45. EXPLAIN Plan for INSERT Statement 6-75
Example 6-46. EXPLAIN Plan for INSERT With SELECT 6-76
Example 6-47. EXPLAIN Plan for Unique UPDATE 6-77
Example 6-48. EXPLAIN Plan With HOUR Date-Time Values 6-79
Example 6-49. EXPLAIN Plan With DAY Date-Time Values 6-80
Example 6-50. DISPLAY STATISTICS Output for QUERY1 6-81
Example 6-51. EXPLAIN Plan for QUERY1 6-82
Example 6-52.
DISPLAY STATISTICS Output for QUERY2 6-84
Example 6-53.
EXPLAIN Plan for QUERY2 6-84
Figures
Figure i. NonStop SQL/MP Library Map xv
Figure 1-1. Selecting Columns From a Table (Projection) 1-3
Figure 1-2. Selecting Rows From a Table (Restriction) 1-4
Figure 1-3. Selecting From Two Tables 1-53
Figure 1-4. UNION of Two Tables 1-62
Figure 1-5. UNION ALL of Two Tables 1-62
Figure 2-1. SQL Components That Execute a Query 2-2
Figure 3-1. Nested Join 3-25