SQL/MX 3.2 Query Guide (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Query Guide—663851-002
Index-6
R
noncacheable queries 6-4
overview of 6-1
sizing 6-6
Query tree
compiler 1-2
Queues 1-19
R
Range predicates, intervening, how MDAM
handles 2-16
Redundant predicates, how MDAM
handles 2-17
REMOTE_ESP_ALLOCATION system
default setting 4-12
Repartition 8-7, 8-8
Replicate by broadcast, in hash join 8-10
Replicate, no broadcast, in nested join 8-10
ROOT operator 7-59
Rows, duplicate 2-17
S
SAMPLE operator 7-61
SAMPLE_FILE_SCAN operator 7-62
Sampling
accuracy 3-7
cluster 3-7
periodic 3-7
random row 3-7
updating statistics 3-5
SCAN operator, in parallel plans 8-6
Scheduler-driven task model 1-19
Search memory 1-4
Search space 1-4
Select, in parallel plans 8-12
SEQUENCE operator 7-63
SEQUENCEGENERATOR operator 7-65
SET SHOWSHAPE command 5-6
SHORTCUT_GROUPBY logical
operator 5-10
SHORTCUT_SCALAR_AGGR
operator 5-10, 7-66
SHOWSHAPE command 5-5
Single subset access 2-14
SORT operator 7-67
Sort, parallel plans 8-12
SORT_GROUPBY operator 7-68
SORT_PARTIAL_AGGR_LEAF
operator 7-69
SORT_PARTIAL_AGGR_ROOT
operator 7-69
SORT_PARTIAL_GROUPBY_LEAF
operator 7-70
SORT_PARTIAL_GROUPBY_ROOT
operator 7-71
SORT_SCALAR_AGGR operator 7-73
SPARSE algorithm, MDAM 2-18
SPLIT_TOP operator 7-74, 8-17
SQL/MP, migrating forced plans 5-10
SQL/MX compiler
binder 1-2
codegen 1-2
description of 1-1
metadata and statistics 1-2
normalizer 1-2
optimizer 1-2
parser 1-2
steps to compile a query 1-2
Statistics
analyzing impact of updating 3-5
default 3-2
DISPLAY STATISTICS 4-21
histogram updating 3-1, 3-2
importance for parallelism in 8-24
Measure product 4-22
multicolumn statistics 3-8
performance, effects on 3-5
run-time 4-21
sampling 3-5
testing before updating 3-8
Storage-key access
approximate cost 2-2
description of 2-1
TP663851.fm Page 6 Thursday, August 2, 2012 4:47 PM