SQL/MX 3.1 Query Guide (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
Index-4
N
tips for using 2-17
Measure entity
SQLPROC 4-22
SQLSTMT 4-23
Measure product 4-22
MERGE_ANTI_SEMI_JOIN operator 7-41
MERGE_JOIN operator 7-42
MERGE_SEMI_JOIN operator 7-44
MERGE_UNION operator 7-45
Migrating from SQL/MP, forced plans 5-10
Multicolumn statistics 3-8
MultiUnion operator 7-46
N
Nested join, replicate, no broadcast 8-10
NESTED_ANTI_SEMI_JOIN operator 7-46
NESTED_JOIN operator 7-47
NESTED_SEMI_JOIN operator 7-49
NEXTVALUEFOR operator 7-50
NonStop Data Access Manager (DAM)
See DAM
Normalizer 1-2
O
ODBC data source 4-14
OLT optimization
displaying 1-9
enabling 1-8
valid queries and operators 1-9
Operator groups 7-3, 7-4
Operator parallelism 8-2
Operator tree
compiler 1-2
description of 4-3
lisp-like format 5-5
partially shaping 5-9
translate to text format 5-5
Operators 7-1
Optimality, principle of 1-4
Optimization rules 1-3
OPTIMIZATION_LEVEL system default
setting 4-10
Optimizer
branch and bound programming 1-3
description of 1-2
execution plans 5-1
implementation rules 1-5
multipass optimization 1-5
principle of optimality 1-3
search memory 1-4
search space 1-4
top-down approach 1-3
transformation rules 1-4
OPTS_PUSH_DOWN_DAM system default
setting 4-11
OR operator 1-10
OR optimization 1-10
OR predicates 1-10
OR predicates, how MDAM handles 2-16
ORDERED_HASH_ANTI_SEMI_JOIN
operator 7-50
ORDERED_HASH_JOIN operator 7-52
ORDERED_HASH_SEMI_JOIN
operator 7-53
ORDERED_UNION operator 7-54
P
PACK operator 7-56
Parallel plans
forcing 5-13
group by 8-11
influencing 8-24
inserting 8-12
parallelism, recognizing 8-13
plan fragments 8-16, 8-17
SCAN operator 8-6
selects 8-12
sort 8-12
understanding EXPLAIN output 8-12
union 8-11
TP663851.fm Page 4 Monday, October 17, 2011 11:48 AM