SQL/MX 3.1 Query Guide (H06.23+, J06.12+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
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 Monday, October 17, 2011 11:48 AM