SQL/MX 2.x Query Guide (H06.04+, J06.03+)

SQL/MX Operators
HP NonStop SQL/MX Query Guide—540437-005
7-2
•
PACK Operator on page 7-53
•
PARTITION_ACCESS Operator on page 7-54
•
ROOT Operator on page 7-56
•
SAMPLE Operator on page 7-58
•
SAMPLE_FILE_SCAN Operator on page 7-59
•
SEQUENCE Operator on page 7-60
•
SHORTCUT_SCALAR_AGGR Operator on page 7-62
•
SORT Operator on page 7-62
•
SORT_GROUPBY Operator on page 7-63
•
SORT_PARTIAL_AGGR_LEAF Operator on page 7-64
•
SORT_PARTIAL_AGGR_ROOT Operator on page 7-65
•
SORT_PARTIAL_GROUPBY_LEAF Operator on page 7-66
•
SORT_PARTIAL_GROUPBY_ROOT Operator on page 7-67
•
SORT_SCALAR_AGGR Operator on page 7-68
•
SPLIT_TOP Operator on page 7-69
•
SUBSET_DELETE Operator on page 7-70
•
SUBSET_UPDATE Operator on page 7-71
•
TRANSPOSE Operator on page 7-73
•
TUPLE_FLOW Operator on page 7-74
•
TUPLELIST Operator on page 7-75
•
UNARY_UNION Operator on page 7-76
•
UNIQUE_DELETE Operator on page 7-78
•
UNIQUE_UPDATE Operator on page 7-79
•
UNPACK Operator on page 7-80
•
VALUES Operator on page 7-81
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.
Group Operator
User-Defined
Routine
CALL
DAM Subset FILE_SCAN
INDEX_SCAN
SUBSET_DELETE
SUBSET_UPDATE
DAM Unique CURSOR_DELETE
CURSOR_UPDATE
FILE_SCAN_UNIQUE
INDEX_SCAN_UNIQUE
UNIQUE_DELETE
UNIQUE_UPDATE