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

SQL/MX Operators
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
7-4
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
Rowset PACK
UNPACK
Sort SORT
Stored Function EXPLAIN
Tuple EXPR
TUPLELIST
VALUES
Group Operator
TP663851.fm Page 4 Wednesday, January 30, 2013 5:37 PM