SQL/MX 3.2 Query Guide (H06.25+, J06.14+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.2 Query Guide—663851-002
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 Thursday, August 2, 2012 4:47 PM