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

HP NonStop SQL/MX Query Guide—523728-003
Index-1
Index
A
Access cost
alternate-index access 2-5
index-only access 2-4
MDAM 2-14
single subset access 2-13
storage-key access 2-2
table scan 2-6
Access method
alternate index 2-4
alternative to key-sequenced
access 2-5
index only 2-2
storage-key 2-1
Access path
description of 2-1
forcing 2-11
MDAM 2-12
unexpected 2-9
Alternate-index access
approximate cost 2-5
description of 2-4
update issues 2-9
ATTEMPT_ASYNCHRONOUS_ACCESS
system default setting 8-25
ATTEMPT_ESP_PARALLELISM system
default setting 8-25
B
Binder 1-2
Branch and bound programming 1-3
C
CALL operator 7-4
Codegen 1-2
Compiler
See SQL compiler
Contradictory predicates, how MDAM
handles 2-16
CONTROL QUERY DEFAULT
INTERACTIVE_ACCESS system
default setting 2-6
CONTROL QUERY SHAPE statement
deferring exchange and sort
operators 5-16
dependencies 5-1
forcing access path 2-11
MDAM OFF 2-13
scope of 5-8
turning off 5-8
Cost, access
See Access cost 2-1
CURSOR_DELETE operator 7-5
CURSOR_UPDATE operator 7-6
D
DAM
parallelism 5-13
plan fragments 8-16
Data parallelism 8-1
Data-flow task model 1-14, 8-2
Decoupled keys, matching partitions
join 8-6
Default statistics 3-2
DENSE algorithm, MDAM 2-17
DETAIL_COST in EXPLAIN output
CPU_TIME 4-4
IDLETIME 4-5
IO_TIME 4-4
MSG_TIME 4-4
PROBES 4-5
DISPLAY STATISTICS command 4-20
DISPLAY_EXPLAIN command 4-6
Duplicate rows, how MDAM handles 2-16