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

Index
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
Index-2
E
E
ESP (executor server process)
cost associated with 8-6
how chosen 8-13
operators 8-13
parallelism 5-13
plan fragments 8-16
ESP_ACCESS operator 7-11
ESP_EXCHANGE operator 7-12, 8-16
Exchange nodes 8-3
Executor 1-19
EXPLAIN operator 7-16
EXPLAIN output
columns in 4-3
description of 4-1
generating 5-2
operator tree 4-3
tokens for parallelism 8-16
EXPLAIN output columns
CARDINALITY 4-4
DESCRIPTION 4-4
DETAIL_COST 4-4
LEFT_CHILD_SEQ_ NUM 4-4
MODULE_NAME 4-3
OPERATOR 4-4
OPERATOR_COST 4-4
PLAN_ID 4-4
RIGHT_CHILD_ SEQ_NUM 4-4
SEQ_NUM 4-4
STATEMENT_NAME 4-3
TNAME 4-4
TOTAL_COST 4-4
EXPLAIN_CMD operator 7-17
EXPR operator 7-16
F
FILE_SCAN operator 7-17
FILE_SCAN_UNIQUE operator 7-19
FisrtN operator 7-22
Forced parallel plans
DAM parallelism 5-13
description of 5-13
ESP parallelism 5-13
forcing Type 1 join 5-14
forcing Type 2 join 5-15
joins 5-14
Forced plans
MDAM DENSE or SPARSE 2-19
migrating from SQL/MP 5-10
partially shaping 5-9
summary of steps 5-2
troubleshooting 5-10
using SET SHOWSHAPE to display
plans in effect 5-6
using SHOWSHAPE to get format 5-5
using Visual Query Planner 5-6
views 5-10
writing the CONTROL QUERY SHAPE
statement 5-8
Full table scan
See Table scan
G
GEN_EIDR_BUFFER_SIZE system default
setting 4-9
GEN_PA_BUFFER_SIZE system default
setting 4-9
Group by, parallel plans 8-11
H
Halloween update problem 2-9
HASH_GROUPBY operator 7-22
HASH_PARTIAL_GROUPBY_LEAF
operator 7-24
HASH_PARTIAL_GROUPBY_ROOT
operator 7-25
Histograms
caching 3-4
statistics 3-2
TP663851.fm Page 2 Monday, October 17, 2011 11:48 AM