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

ManualsBrandsHP ManualsServerHP NonStop G-Series

Operators and Operator Groups

HP NonStop SQL/MX Query Guide—523728-003

7-3

Operator Groups and Operators

Data Mining SAMPLE Operator

SEQUENCE Operator

TRANSPOSE Operator

Exchange ESP_EXCHANGE Operator

PARTITION_ACCESS Operator

SPLIT_TOP Operator

Groupby HASH_GROUPBY Operator

HASH_PARTIAL_GROUPBY_LEAF Operator

HASH_PARTIAL_GROUPBY_ROOT Operator

SHORTCUT_SCALAR_AGGR Operator

SORT_GROUPBY Operator

SORT_PARTIAL_AGGR_LEAF Operator

SORT_PARTIAL_AGGR_ROOT Operator

SORT_PARTIAL_GROUPBY_LEAF Operator

SORT_PARTIAL_GROUPBY_ROOT Operator

SORT_SCALAR_AGGR Operator

Insert INSERT Operator

INSERT_VSBB Operator

Join HYBRID_HASH_ANTI_SEMI_JOIN Operator

HYBRID_HASH_JOIN Operator

HYBRID_HASH_SEMI_JOIN Operator

LEFT_HYBRID_HASH_JOIN Operator

LEFT_MERGE_JOIN Operator

LEFT_NESTED_JOIN Operator

LEFT_HYBRID_HASH_JOIN Operator

LEFT_ORDERED_HASH_JOIN Operator

MERGE_ANTI_SEMI_JOIN Operator

MERGE_JOIN Operator

MERGE_SEMI_JOIN Operator

NESTED_ANTI_SEMI_JOIN Operator

NESTED_JOIN Operator

NESTED_SEMI_JOIN Operator

ORDERED_HASH_ANTI_SEMI_JOIN

ORDERED_HASH_JOIN Operator

ORDERED_HASH_SEMI_JOIN Operator

TUPLE_FLOW Operator

Materialize MATERIALIZE Operator

Merge_Union MERGE_UNION Operator

Root ROOT Operator

Rowset PACK Operator

UNPACK Operator

Group Operator