SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-2
Operator Groups and Operators
•
SAMPLE Operator on page 7-42
•
SEQUENCE Operator on page 7-42
•
SHORTCUT_SCALAR_AGGR Operator on page 7-43
•
SORT Operator on page 7-44
•
SORT_GROUPBY Operator on page 7-44
•
SORT_PARTIAL_AGGR_LEAF Operator on page 7-45
•
SORT_PARTIAL_AGGR_ROOT Operator on page 7-46
•
SORT_PARTIAL_GROUPBY_LEAF Operator on page 7-47
•
SORT_PARTIAL_GROUPBY_ROOT Operator on page 7-47
•
SORT_SCALAR_AGGR Operator on page 7-48
•
SPLIT_TOP Operator on page 7-49
•
SUBSET_DELETE Operator on page 7-50
•
SUBSET_UPDATE Operator on page 7-51
•
TRANSPOSE Operator on page 7-52
•
TUPLE_FLOW Operator on page 7-52
•
TUPLELIST Operator on page 7-53
•
UNIQUE_DELETE Operator on page 7-53
•
UNIQUE_UPDATE Operator on page 7-55
•
UNPACK Operator on page 7-56
•
VALUES Operator on page 7-57
Examples provided for most of the operators show the EXPLAIN output for the portion
of the query that contains the referenced operator. In some cases, the query might
have been forced to show a particular operator. 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.
Operator Groups and Operators
Group Operator
User-Defined
Routine
CALL Operator
DAM Subset FILE_SCAN Operator
INDEX_SCAN Operator
SUBSET_DELETE Operator
SUBSET_UPDATE Operator
DAM Unique CURSOR_DELETE Operator
CURSOR_UPDATE Operator
FILE_SCAN_UNIQUE Operator
INDEX_SCAN_UNIQUE Operator
UNIQUE_DELETE Operator
UNIQUE_UPDATE Operator