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

HP NonStop SQL/MX Query Guide—523728-003
7-1
7
Operators and Operator Groups
Use the information in this section to understand the DESCRIPTION column when you
use the EXPLAIN function and when you view query execution plans with the Visual
Query Planner. Operators are frequently called nodes or node types throughout the
SQL/MX documentation set.
This section defines all operators and the operator groups they belong to in alphabetic
order:
•
CALL Operator on page 7-4
•
CURSOR_DELETE Operator on page 7-5
•
CURSOR_UPDATE Operator on page 7-6
•
ESP_EXCHANGE Operator on page 7-6
•
EXPLAIN Operator on page 7-8
•
EXPR Operator on page 7-8
•
FILE_SCAN Operator on page 7-8
•
FILE_SCAN_UNIQUE Operator on page 7-10
•
HASH_GROUPBY Operator on page 7-12
•
HASH_PARTIAL_GROUPBY_LEAF Operator on page 7-13
•
HASH_PARTIAL_GROUPBY_ROOT Operator on page 7-14
•
HYBRID_HASH_ANTI_SEMI_JOIN Operator on page 7-15
•
HYBRID_HASH_JOIN Operator on page 7-16
•
HYBRID_HASH_SEMI_JOIN Operator on page 7-17
•
INDEX_SCAN Operator on page 7-18
•
INDEX_SCAN_UNIQUE Operator on page 7-20
•
INSERT Operator on page 7-21
•
INSERT_VSBB Operator on page 7-22
•
LEFT_HYBRID_HASH_JOIN Operator on page 7-23
•
LEFT_MERGE_JOIN Operator on page 7-24
•
LEFT_NESTED_JOIN Operator on page 7-24
•
LEFT_ORDERED_HASH_JOIN Operator on page 7-25
•
MATERIALIZE Operator on page 7-26
•
MERGE_ANTI_SEMI_JOIN Operator on page 7-28
•
MERGE_JOIN Operator on page 7-28
•
MERGE_SEMI_JOIN Operator on page 7-29
•
MERGE_UNION Operator on page 7-30
•
NESTED_ANTI_SEMI_JOIN Operator on page 7-31
•
NESTED_JOIN Operator on page 7-32
•
NESTED_SEMI_JOIN Operator on page 7-33
•
ORDERED_HASH_ANTI_SEMI_JOIN on page 7-34
•
ORDERED_HASH_JOIN Operator on page 7-35
•
ORDERED_HASH_SEMI_JOIN Operator on page 7-36
•
PACK Operator on page 7-37
•
PARTITION_ACCESS Operator on page 7-38
•
ROOT Operator on page 7-40