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-2

ORDERED_HASH_SEMI_JOIN Operator on page 7-53

ORDERED_UNION Operator on page 7-54

PACK Operator on page 7-56

PARTITION_ACCESS Operator on page 7-57

PROBE_CACHE Operator on page 7-59

PROBE_CACHE Operator on page 7-59

SAMPLE Operator on page 7-61

SAMPLE_FILE_SCAN Operator on page 7-62

SEQUENCE Operator on page 7-63

SEQUENCEGENERATOR Operator on page 7-65

SORT Operator on page 7-67

SORT_GROUPBY Operator on page 7-68

SORT_PARTIAL_AGGR_LEAF Operator on page 7-69

SORT_PARTIAL_AGGR_ROOT Operator on page 7-69

SORT_PARTIAL_GROUPBY_LEAF Operator on page 7-70

SORT_PARTIAL_GROUPBY_ROOT Operator on page 7-71

SORT_SCALAR_AGGR Operator on page 7-73

SPLIT_TOP Operator on page 7-74

SUBSET_DELETE Operator on page 7-75

SUBSET_UPDATE Operator on page 7-76

TRANSPOSE Operator on page 7-78

TUPLE_FLOW Operator on page 7-79

TUPLELIST Operator on page 7-80

UNARY_UNION Operator on page 7-81

UNIQUE_DELETE Operator on page 7-83

UNIQUE_UPDATE Operator on page 7-84

UNPACK Operator on page 7-85

VALUES Operator on page 7-86
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 Monday, October 17, 2011 11:48 AM