SQL/MX 3.x Query Guide (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Query Guide—640323-001
Index-3
I
HIST_SCRATCH_VOL default attribute 3-5
HYBRID_HASH_ANTI_SEMI_JOIN
operator 7-24
HYBRID_HASH_JOIN operator 7-25
HYBRID_HASH_SEMI_JOIN operator 7-26
I
Implementation rules 1-5
Independent parallelism 8-2
Index, performance improvement 1-10
Index-only access
approximate cost 2-4
description of 2-2
using 2-3
INDEX_SCAN operator 7-27
INDEX_SCAN_UNIQUE operator 7-29
INSERT operator 7-31
Insert, in parallel plans 8-12
INSERT_VSBB operator 7-32
INTERACTIVE_ACCESS system default
setting 2-6
J
Joins
alternate index access 2-4
logical partition grouping 8-8
logical subpartition alignment 8-9
matching partitions 8-6
parallel access to inner table 8-10
range repartitioned 8-7
replicate by broadcast 8-10
replicate no broadcast 8-10
Type 1 join 8-6
Type 2 join 8-10
when partition boundaries do not
match 8-9
JOIN_ORDER_BY_USER system default
setting 4-10
K
Key predicates, how MDAM handles 2-16
L
LEFT_HYBRID_HASH_JOIN operator 7-33
LEFT_MERGE_JOIN operator 7-34
LEFT_NESTED_JOIN operator 7-35
LEFT_ORDERED_HASH_JOIN
operator 7-36
Logical expressions 1-3, 1-4
Logical operators 5-9
M
Matching partitions join, decoupled
keys 8-6
MATERIALIZE operator 7-38
MAX_ESPS_PER_CPU_PER_OP system
default setting 8-25
MDAM (MultiDimensional Access
Method) 1-10
compared to single subset access 2-14
controlling the number of key
columns 2-18
cost 2-15
DENSE algorithm 2-18
description of 2-13
duplicate rows 2-17
forcing DENSE or SPARSE 2-19
forcing with CONTROL QUERY
SHAPE 2-14
IN lists 2-16
intervening range predicates 2-16
joins and 1-10
key predicates 2-16
multiple tables in a query and 1-10
OR predicates 2-16
redundant and contradictory
predicates 2-17
sort order 2-17
SPARSE algorithm 2-18