SQL/MX 3.1 Query Guide (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
Index-7
T
SUBSET_DELETE operator 7-75
SUBSET_UPDATE operator 7-76
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-78
Troubleshooting, forced plans 5-10
TUPLELIST operator 7-80
TUPLE_FLOW operator 7-79
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-81
Union, parallel plans 8-11
UNIQUE_DELETE operator 7-83
UNIQUE_UPDATE operator 7-84
UNPACK operator 7-85
Update, Halloween problem 2-9
V
VALUES operator 7-86
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
TP663851.fm Page 7 Monday, October 17, 2011 11:48 AM