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

Contents
HP NonStop SQL/MX Query Guide—523728-003
iv
7. Operators and Operator Groups (continued)
7. Operators and Operator Groups (continued)
HASH_GROUPBY Operator 7-12
HASH_PARTIAL_GROUPBY_LEAF Operator 7-13
HASH_PARTIAL_GROUPBY_ROOT Operator 7-14
HYBRID_HASH_ANTI_SEMI_JOIN Operator 7-15
HYBRID_HASH_JOIN Operator 7-16
HYBRID_HASH_SEMI_JOIN Operator 7-17
INDEX_SCAN Operator 7-18
INDEX_SCAN_UNIQUE Operator 7-20
INSERT Operator 7-21
INSERT_VSBB Operator 7-22
LEFT_HYBRID_HASH_JOIN Operator 7-23
LEFT_MERGE_JOIN Operator 7-24
LEFT_NESTED_JOIN Operator 7-24
LEFT_ORDERED_HASH_JOIN Operator 7-25
MATERIALIZE Operator 7-26
MERGE_ANTI_SEMI_JOIN Operator 7-28
MERGE_JOIN Operator 7-28
MERGE_SEMI_JOIN Operator 7-29
MERGE_UNION Operator 7-30
NESTED_ANTI_SEMI_JOIN Operator 7-31
NESTED_JOIN Operator 7-32
NESTED_SEMI_JOIN Operator 7-33
ORDERED_HASH_ANTI_SEMI_JOIN 7-34
ORDERED_HASH_JOIN Operator 7-35
ORDERED_HASH_SEMI_JOIN Operator 7-36
PACK Operator 7-37
PARTITION_ACCESS Operator 7-38
ROOT Operator 7-40
SAMPLE Operator 7-42
SEQUENCE Operator 7-42
SHORTCUT_SCALAR_AGGR Operator 7-43
SORT Operator 7-44
SORT_GROUPBY Operator 7-44
SORT_PARTIAL_AGGR_LEAF Operator 7-45
SORT_PARTIAL_AGGR_ROOT Operator 7-46
SORT_PARTIAL_GROUPBY_LEAF Operator 7-47
SORT_PARTIAL_GROUPBY_ROOT Operator 7-47
SORT_SCALAR_AGGR Operator 7-48