SQL/MX 3.x Query Guide (H06.22+, J06.11+)

SQL/MX Operators
HP NonStop SQL/MX Query Guide—640323-001
7-2
•
PACK Operator on page 7-53
•
PARTITION_ACCESS Operator on page 7-54
•
PROBE_CACHE Operator on page 7-56
•
PROBE_CACHE Operator on page 7-56
•
SAMPLE Operator on page 7-58
•
SAMPLE_FILE_SCAN Operator on page 7-59
•
SEQUENCE Operator on page 7-61
•
SHORTCUT_SCALAR_AGGR Operator on page 7-62
•
SORT Operator on page 7-63
•
SORT_GROUPBY Operator on page 7-64
•
SORT_PARTIAL_AGGR_LEAF Operator on page 7-65
•
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-69
•
SPLIT_TOP Operator on page 7-70
•
SUBSET_DELETE Operator on page 7-71
•
SUBSET_UPDATE Operator on page 7-72
•
TRANSPOSE Operator on page 7-74
•
TUPLE_FLOW Operator on page 7-75
•
TUPLELIST Operator on page 7-76
•
UNARY_UNION Operator on page 7-77
•
UNIQUE_DELETE Operator on page 7-79
•
UNIQUE_UPDATE Operator on page 7-80
•
UNPACK Operator on page 7-81
•
VALUES Operator on page 7-82
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