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

Contents
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
v
8. Parallelism
PACK Operator 7-56
PARTITION_ACCESS Operator 7-57
PROBE_CACHE Operator 7-59
ROOT Operator 7-59
SAMPLE Operator 7-61
SAMPLE_FILE_SCAN Operator 7-62
SEQUENCE Operator 7-63
SEQUENCEGENERATOR Operator 7-65
The description field for the operator contains: 7-65
SHORTCUT_SCALAR_AGGR Operator
7-66
SORT Operator
7-67
SORT_GROUPBY Operator 7-68
SORT_PARTIAL_AGGR_LEAF Operator 7-69
SORT_PARTIAL_AGGR_ROOT Operator 7-69
SORT_PARTIAL_GROUPBY_LEAF Operator 7-70
SORT_PARTIAL_GROUPBY_ROOT Operator 7-71
SORT_SCALAR_AGGR Operator 7-73
SPLIT_TOP Operator 7-74
SUBSET_DELETE Operator 7-75
SUBSET_UPDATE Operator 7-76
TRANSPOSE Operator 7-78
TUPLE_FLOW Operator 7-79
TUPLELIST Operator 7-80
UNARY_UNION Operator 7-81
UNIQUE_DELETE Operator
7-83
UNIQUE_UPDATE Operator 7-84
UNPACK Operator
7-85
VALUES Operator
7-86
8. Parallelism
Types of Parallelism in NonStop SQL/MX 8-1
Partitioned Parallelism
8-1
Pipelined Parallelism
8-2
Independent Parallelism 8-2
Parallel Execution Principles 8-2
Query Plan as a Data Flow Tree
8-2
Exchange Nodes and Plan Fragments
8-3
DAM and ESP Parallelism 8-5
Parallel Plan Generation 8-6
TP663851.fm Page v Monday, October 17, 2011 11:48 AM