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

Index
HP NonStop SQL/MX Query Guide—523728-003
Index-3
I
I
Implementation rules 1-4
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-18
INDEX_SCAN_UNIQUE operator 7-20
INSERT operator 7-21
Insert, in parallel plans 8-12
INSERT_VSBB operator 7-22
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
K
Key predicates, how MDAM handles 2-15
L
LEFT_HYBRID_HASH_JOIN operator 7-23
LEFT_MERGE_JOIN operator 7-24
LEFT_NESTED_JOIN operator 7-24
LEFT_ORDERED_HASH_JOIN
operator 7-25
Logical expressions 1-3, 1-4
Logical operators 5-9
M
Matching partitions join, decoupled
keys 8-6
MATERIALIZE operator 7-26
MAX_ESPS_PER_CPU_PER_OP system
default setting 8-25
MDAM (MultiDimensional Access
Method) 1-10
compared to single subset access 2-13
controlling the number of key
columns 2-17
cost 2-14
DENSE algorithm 2-17
description of 2-12
duplicate rows 2-16
forcing DENSE or SPARSE 2-18
forcing with CONTROL QUERY
SHAPE 2-13
IN lists 2-15
intervening range predicates 2-15
joins and 1-10
key predicates 2-15
multiple tables in a query and 1-10
OR predicates 2-15
redundant and contradictory
predicates 2-16
sort order 2-16
SPARSE algorithm 2-17
tips for using 2-16
Measure entity
SQLPROC 4-21
SQLSTMT 4-22
Measure product 4-21
MERGE_ANTI_SEMI_JOIN operator 7-28
MERGE_JOIN operator 7-28
MERGE_SEMI_JOIN operator 7-29