SQL/MP Query Guide

Index
HP NonStop SQL/MP Query Guide—524488-003
Index-9
Q
Predicates (continued)
ANY 1-38
base table 3-14
BETWEEN 1-32
comparison 1-31
connected by OR operators 1-35
controlling generation of
additional 3-20
cost of 5-16
efficient writing of 3-15
eliminating 3-11
evaluating 3-4
executor 3-15
EXISTS 1-37
IN 1-36, 3-7
index 3-13
join 3-18, 3-40
key 3-13
LIKE
description of 1-33
efficiency and 3-24
with CHAR columns 1-34
with columns of varying length 1-34
with TRIM 1-35
missing key columns 3-16
multivalued 1-40, 3-19
NULL 1-39
operators in 1-30
OR operators in 3-22
positioning 3-13
quantified (SOME, ANY, ALL) 1-38
queries with 1-30
selectivity 5-1, 5-4, 5-5, 5-6
simplifying 3-12
SOME 1-38
transformation 3-4
Prefix 3-7
PREPARE command (SQLCI) 6-3
PREPARE statement 3-3
Primary access
description of 4-4
EXPLAIN plan for 6-18
Probe phase during hash join
operation 3-30
Processes, controlling creation of 4-31
Processor assignment 2-5
Programmatic SQL
SELECT statement in 1-10
using cursors in 1-12
Projection of columns 1-3
Q
Quantified predicate (SOME, ANY,
ALL) 1-38
Query
See also Query optimization
cost of 5-11
description of 1-1
executing
by disk process 2-3
by executor 2-3
by file system 2-3
inner join operation 1-53, 1-54
joining tables 1-51
left join operation 1-53, 1-55
multistep 1-65
outer 1-28
parallel processing of 4-13
predicates in 1-30
preparing 3-3
refining 3-3
search conditions in 1-8
statistics on 6-2
subqueries as part of 1-28
UNION operator in 1-61
Query execution plan
choosing 5-1, 5-19
cost 5-11, 6-12
forcing 5-20