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

Index
HP NonStop SQL/MX Query Guide—523728-003
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_EXCHANGE operator 7-6, 8-16
Exchange nodes 8-3
Execution plan
See Query execution plan
Executor 1-14
EXPLAIN operator 7-8
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
EXPR operator 7-8
F
FILE_SCAN operator 7-8
FILE_SCAN_UNIQUE operator 7-10
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-18
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
Group by, parallel plans 8-11
H
Halloween update problem 2-9
HASH_GROUPBY operator 7-12
HASH_PARTIAL_GROUPBY_LEAF
operator 7-13
HASH_PARTIAL_GROUPBY_ROOT
operator 7-14
Histograms
caching 3-4
statistics 3-2
HYBRID_HASH_ANTI_SEMI_JOIN
operator 7-15
HYBRID_HASH_JOIN operator 7-16
HYBRID_HASH_SEMI_JOIN operator 7-17