SQL/MX 2.x Query Guide (H06.04+, J06.03+)

Index
HP NonStop SQL/MX Query Guide—540437-005
Index-6
R
Query plan caching (continued)
description 6-1
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-56
Rows, duplicate 2-17
S
SAMPLE operator 7-57
SAMPLE_FILE_SCAN operator 7-58
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-60
SET SHOWSHAPE command 5-6
SHORTCUT_GROUPBY logical
operator 5-10
SHORTCUT_SCALAR_AGGR
operator 5-10, 7-61
SHOWSHAPE command 5-5
Single subset access 2-14
SORT operator 7-62
Sort, parallel plans 8-12
SORT_GROUPBY operator 7-63
SORT_PARTIAL_AGGR_LEAF
operator 7-63
SORT_PARTIAL_AGGR_ROOT
operator 7-64
SORT_PARTIAL_GROUPBY_LEAF
operator 7-65
SORT_PARTIAL_GROUPBY_ROOT
operator 7-66
SORT_SCALAR_AGGR operator 7-67
SPARSE algorithm, MDAM 2-18
SPLIT_TOP operator 7-68, 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