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-2

ORDERED_HASH_SEMI_JOIN Operator on page 7-54

ORDERED_UNION Operator on page 7-56

PACK Operator on page 7-57

PARTITION_ACCESS Operator on page 7-58

PROBE_CACHE Operator on page 7-60

SAMPLE Operator on page 7-62

SAMPLE_FILE_SCAN Operator on page 7-63

SEQUENCE Operator on page 7-65

SEQUENCEGENERATOR Operator on page 7-66

SORT Operator on page 7-69

SORT_GROUPBY Operator on page 7-71

SORT_PARTIAL_AGGR_LEAF Operator on page 7-71

SORT_PARTIAL_AGGR_ROOT Operator on page 7-72

SORT_PARTIAL_GROUPBY_LEAF Operator on page 7-73

SORT_PARTIAL_GROUPBY_ROOT Operator on page 7-74

SORT_SCALAR_AGGR Operator on page 7-75

SPLIT_TOP Operator on page 7-76

SUBSET_DELETE Operator on page 7-77

SUBSET_UPDATE Operator on page 7-78

TRANSPOSE Operator on page 7-80

TUPLE_FLOW Operator on page 7-81

TUPLELIST Operator on page 7-83

UNARY_UNION Operator on page 7-83

UNIQUE_DELETE Operator on page 7-85

UNIQUE_UPDATE Operator on page 7-86

UNPACK Operator on page 7-87

VALUES Operator on page 7-89
For information about reading the EXPLAIN output, see Description of the EXPLAIN
Function Results on page 4-3.
Operator groups are used to conveniently group operators of a similar type. For
example, the Join group contains all operators that use joins.
TP663851.fm Page 2 Wednesday, January 30, 2013 5:37 PM