SQL/MX 3.x Query Guide (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Query Guide—640323-001
Index-7
T
Storage-key access
approximate cost 2-2
description of 2-1
SUBSET_DELETE operator 7-69
SUBSET_UPDATE operator 7-70
System default setting
GEN_EIDR_BUFFER_SIZE 4-9
GEN_PA_BUFFER_SIZE 4-9
JOIN_ORDER_BY_USER 4-10
OPTIMIZATION_LEVEL 4-10
OPTS_PUSH_DOWN_DAM 4-11
REMOTE_ESP_ALLOCATION 4-12
ZIG_ZAG_TREES 4-13
System default settings and
parallelism 8-25
T
Table scan
approximate cost of 2-6
avoiding 2-5, 2-6
description of 2-5
TRANSPOSE operator 7-72
Troubleshooting, forced plans 5-10
TUPLELIST operator 7-74
TUPLE_FLOW operator 7-73
Type 1 join
forcing 5-14
matching partition algorithm 8-6
Type 2 join
forcing 5-15
replicate by broadcast 8-10
replicate, no broadcast 8-10
U
UNARY_UNION operator 7-75
Union, parallel plans 8-11
UNIQUE_DELETE operator 7-76
UNIQUE_UPDATE operator 7-78
UNPACK operator 7-79
Update, Halloween problem 2-9
V
VALUES operator 7-80
Views, forced plans 5-10
Visual Query Planner
accessing 4-14
connecting to ODBC with 4-15
online help 4-14
purpose of 4-14
requirements 4-14
summary of 4-15
toolbar 4-16
Z
ZIG_ZAG_TREES system default
setting 4-13