SQL/MX 3.2.1 Query Guide (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
v
8. Parallelism
NESTED_SEMI_JOIN Operator 7-51
7-51
ORDERED_HASH_JOIN Operator 7-53
ORDERED_HASH_SEMI_JOIN Operator 7-54
ORDERED_UNION Operator 7-55
PACK Operator 7-57
PARTITION_ACCESS Operator 7-58
PROBE_CACHE Operator 7-60
ROOT Operator 7-60
SAMPLE Operator
7-62
SAMPLE_FILE_SCAN Operator
7-63
SEQUENCE Operator 7-64
SEQUENCEGENERATOR Operator 7-66
SHORTCUT_SCALAR_AGGR Operator 7-67
SORT Operator 7-68
SORT_GROUPBY Operator 7-69
SORT_PARTIAL_AGGR_LEAF Operator 7-70
SORT_PARTIAL_AGGR_ROOT Operator 7-70
SORT_PARTIAL_GROUPBY_LEAF Operator 7-71
SORT_PARTIAL_GROUPBY_ROOT Operator 7-72
SORT_SCALAR_AGGR Operator 7-74
SPLIT_TOP Operator 7-75
SUBSET_DELETE Operator 7-76
SUBSET_UPDATE Operator 7-77
TRANSPOSE Operator
7-79
TUPLE_FLOW Operator 7-80
TUPLELIST Operator
7-81
UNARY_UNION Operator
7-82
UNIQUE_DELETE Operator
7-84
UNIQUE_UPDATE Operator 7-85
UNPACK Operator
7-86
VALUES Operator
7-87
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
TP663851.fm Page v Wednesday, January 30, 2013 5:37 PM