SQL/MX 2.x Query Guide (H06.04+, J06.03+)

SQL/MX Operators
HP NonStop SQL/MX Query Guide—540437-005
7-3
Data Mining SAMPLE
SEQUENCE
TRANSPOSE
Exchange ESP_EXCHANGE
PARTITION_ACCESS
SPLIT_TOP
Groupby HASH_GROUPBY
HASH_PARTIAL_GROUPBY_LEAF
HASH_PARTIAL_GROUPBY_ROOT
SHORTCUT_SCALAR_AGRR
SORT_GROUPBY
SORT_PARTIAL_AGGR_LEAF
SORT_PARTIAL_AGGR_ROOT
SORT_PARTIAL_GROUPBY_LEAF
SORT_PARTIAL_GROUPBY_ROOT
SORT_SCALAR_AGGR
Insert INSERT
INSERT_VSBB
Join HYBRID_HASH_ANTI_SEMI_JOIN
HYBRID_HASH_JOIN
HYBRID_HASH_SEMI_JOIN
LEFT_HYBRID_HASH_JOIN
LEFT_MERGE_JOIN
LEFT_NESTED_JOIN
LEFT_ORDERED_HASH_JOIN
MERGE_ANTI_SEMI_JOIN
MERGE_JOIN
MERGE_SEMI_JOIN
NESTED_ANTI_SEMI_JOIN
NESTED_JOIN
NESTED_SEMI_JOIN
ORDERED_HASH_ANTI_SEMI_JOIN
ORDERED_HASH_JOIN
ORDERED_HASH_SEMI_JOIN
TUPLE_FLOW
Materialize MATERIALIZE
Union BLOCKED_UNION
MERGE_UNION
ORDERED_UNION
UNARY_UNION
Root ROOT
Group Operator