SQL/MX 3.x Query Guide (H06.22+, J06.11+)

HP NonStop SQL/MX Query Guide—640323-001
4
7. SQL/MX Operators
INSERT Operator 7-31
INSERT_VSBB Operator 7-32
LEFT_HYBRID_HASH_JOIN Operator 7-33
LEFT_MERGE_JOIN Operator 7-34
LEFT_NESTED_JOIN Operator 7-36
LEFT_ORDERED_HASH_JOIN Operator 7-37
MATERIALIZE Operator 7-38
MERGE_ANTI_SEMI_JOIN Operator 7-39
MERGE_JOIN Operator 7-40
MERGE_SEMI_JOIN Operator 7-42
MERGE_UNION Operator 7-43
MultiUnion Operator 7-44
NESTED_ANTI_SEMI_JOIN Operator 7-44
NESTED_JOIN Operator 7-45
NESTED_SEMI_JOIN Operator 7-47
ORDERED_HASH_ANTI_SEMI_JOIN 7-48
ORDERED_HASH_JOIN Operator 7-49
ORDERED_HASH_SEMI_JOIN Operator 7-50
ORDERED_UNION Operator 7-52
PACK Operator 7-53
PARTITION_ACCESS Operator 7-54
PROBE_CACHE Operator 7-56
ROOT Operator 7-57
SAMPLE Operator 7-58
SAMPLE_FILE_SCAN Operator 7-59
SEQUENCE Operator 7-61
SHORTCUT_SCALAR_AGGR Operator 7-62
SORT Operator
7-63
SORT_GROUPBY Operator
7-64
SORT_PARTIAL_AGGR_LEAF Operator 7-65
SORT_PARTIAL_AGGR_ROOT Operator 7-65
SORT_PARTIAL_GROUPBY_LEAF Operator 7-66
SORT_PARTIAL_GROUPBY_ROOT Operator 7-67
SORT_SCALAR_AGGR Operator 7-69
SPLIT_TOP Operator
7-70
SUBSET_DELETE Operator
7-71
SUBSET_UPDATE Operator 7-72
TRANSPOSE Operator 7-74
TUPLE_FLOW Operator 7-75