SQL/MP Query Guide

Index
HP NonStop SQL/MP Query Guide—524488-003
Index-4
F
EXECUTE statement 3-3
Execution statistics, displaying 6-3
Execution-time name resolution 4-33
Executor 2-3
Executor predicate
description of 3-15
EXPLAIN plan and 3-12
EXPLAIN plan evaluation 6-14
list of 3-15
Executor server process (ESP)
description 4-14
processor assignment 2-5
EXISTS predicate
description of 1-37
performance implication 3-16
EXPLAIN examples
bounded predicates in 6-20
CASE
for converting tables 6-36
for finding the highest value in a
row 6-35
for ignoring largest and smallest
values 6-38
using with aggregates 6-34
using with multiple conditions 6-33
cross product join 6-53
cursor DELETE 6-73
cursor UPDATE 6-72
date-time values 6-78
DISTINCT 6-24
GROUP BY
using a parallel plan 6-28
using a serial plan 6-26
hash join 6-49
index-only access 6-19
INSERT 6-74
INSERT-SELECT 6-75
join queries 6-48
key predicates 6-23
key-sequenced merge join 6-60, 6-62
EXPLAIN examples (continued)
left join 6-64, 6-66
MAX optimization 6-70
MDAM 6-42, 6-43, 6-44
multiple predicate sets 6-46
nested inner join 6-51
ORDER BY 6-6, 6-10, 6-25
parallel execution 6-49, 6-58
primary access versus index-only
access 6-18
selectivity 6-47
simple SELECT 6-16
subqueries 6-29
SUBSTRING 6-39
UNION operation 6-68
UPDATE 6-77
EXPLAIN plan
access path and 6-13
block buffering and 6-14
correlated subquery and 6-13
cost and 6-12
effect of uneven data distribution
on 4-9
executor evaluation and 6-14
generating 6-9
interpreting 6-12
key predicates and 6-13
locking and 6-15
parallel execution and 6-15
selectivity and 6-15
sequential cache and 6-14
sort operations and 6-13
table scans and 6-13
EXTEND function 1-24, 1-27
F
FETCH cursor statement 1-12
File system 2-3
FREE RESOURCES statement and
cursors 1-13