SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Query Guide—523728-003
Index-4
N
MERGE_UNION operator 7-30
Migrating from SQL/MP, forced plans 5-10
Multicolumn statistics 3-7
N
Nested join, replicate, no broadcast 8-10
NESTED_ANTI_SEMI_JOIN operator 7-31
NESTED_JOIN operator 7-32
NESTED_SEMI_JOIN operator 7-33
New in this release vii
NonStop Data Access Manager (DAM)
See DAM
Normalizer 1-2
O
ODBC data source 4-13
OLT optimization
displaying 1-9
enabling 1-8
valid queries and operators 1-9
Operator groups 7-2, 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
Optimizer
branch and bound programming 1-3
description of 1-2
execution plans 5-1
implementation rules 1-4
multipass optimization 1-5
principle of optimality 1-3
search memory 1-4
Optimizer (continued)
search space 1-4
top-down approach 1-3
transformation rules 1-4
OR operator 1-10
OR optimization 1-10
OR predicates 1-10
OR predicates, how MDAM handles 2-15
ORDERED_HASH_ANTI_SEMI_JOIN
operator 7-34
ORDERED_HASH_JOIN operator 7-35
ORDERED_HASH_SEMI_JOIN
operator 7-36
P
PACK operator 7-37
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
Parallelism
combining different types 8-12
degree of 8-21
EXPLAIN output 8-12
forcing plans with 5-13
group by 8-11
how optimizer avoids repartitioning 8-8
independent 8-2
influencing 8-24
insert 8-12
matching partitions algorithm 8-6
multilevel 8-12