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

Index
HP NonStop SQL/MX Query Guide—523728-003
Index-6
R
R
Range predicates, intervening, how MDAM
handles 2-15
Redundant predicates, how MDAM
handles 2-16
Repartition 8-7, 8-8
Replicate by broadcast, in hash join 8-10
Replicate, no broadcast, in nested join 8-10
ROOT operator 7-40
Rows, duplicate 2-16
S
SAMPLE operator 7-42
Sampling
accuracy 3-6
cluster 3-6
periodic 3-6
random row 3-6
updating statistics 3-5
SCAN operator, in parallel plans 8-6
Scheduler-driven task model 1-14
Search memory 1-4
Search space 1-4
Select, in parallel plans 8-12
SEQUENCE operator 7-42
SET SHOWSHAPE command 5-6
SHORTCUT_GROUPBY logical
operator 5-10
SHORTCUT_SCALAR_AGGR
operator 5-10, 7-43
SHOWSHAPE command 5-5
Single subset access 2-13
SORT operator 7-44
Sort, parallel plans 8-12
SORT_GROUPBY operator 7-44
SORT_PARTIAL_AGGR_LEAF
operator 7-45
SORT_PARTIAL_AGGR_ROOT
operator 7-46
SORT_PARTIAL_GROUPBY_LEAF
operator 7-47
SORT_PARTIAL_GROUPBY_ROOT
operator 7-47
SORT_SCALAR_AGGR operator 7-48
SPARSE algorithm, MDAM 2-17
SPLIT_TOP operator 7-49, 8-17
SQL 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
SQL/MP, migrating forced plans 5-10
Statistics
analyzing impact of updating 3-5
default 3-2
DISPLAY STATISTICS 4-20
histogram updating 3-1, 3-2
importance for parallelism in 8-24
Measure product 4-21
multicolumn statistics 3-7
performance, effects on 3-5
run-time 4-20
sampling 3-5
testing before updating 3-7
Storage-key access
approximate cost 2-2
description of 2-1
SUBSET_DELETE operator 7-50
SUBSET_UPDATE operator 7-51
System default settings and
parallelism 8-25
T
Table scan
approximate cost of 2-6
avoiding 2-5, 2-6
description of 2-5