SQL/MX 3.1 Query Guide (H06.23+, J06.12+)
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
7-1
7 SQL/MX Operators
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. For information about using the EXPLAIN function and
Visual Query Planner, see Section 4, Reviewing Query Execution Plans.
This section defines all operators in alphabetic order:
BLOCKED_UNION Operator on page 7-5
CALL Operator on page 7-6
CURSOR_DELETE Operator on page 7-8
CURSOR_UPDATE Operator on page 7-9
EXPLAIN Operator on page 7-16
ESP_ACCESS Operator on page 7-11
ESP_EXCHANGE Operator on page 7-12
EXPR Operator on page 7-16
EXPLAIN_CMD Operator on page 7-17
FILE_SCAN Operator on page 7-17
FILE_SCAN_UNIQUE Operator on page 7-19
FirstN Operator on page 7-22
HASH_GROUPBY Operator on page 7-22
HASH_PARTIAL_GROUPBY_LEAF Operator on page 7-24
HASH_PARTIAL_GROUPBY_ROOT Operator on page 7-25
HYBRID_HASH_ANTI_SEMI_JOIN Operator on page 7-26
HYBRID_HASH_JOIN Operator on page 7-27
HYBRID_HASH_SEMI_JOIN Operator on page 7-28
INDEX_SCAN Operator on page 7-29
INDEX_SCAN_UNIQUE Operator on page 7-31
INSERT Operator on page 7-33
INSERT_VSBB Operator on page 7-34
LEFT_HYBRID_HASH_JOIN Operator on page 7-35
LEFT_MERGE_JOIN Operator on page 7-36
LEFT_NESTED_JOIN Operator on page 7-38
LEFT_ORDERED_HASH_JOIN Operator on page 7-39
MATERIALIZE Operator on page 7-40
MERGE_ANTI_SEMI_JOIN Operator on page 7-41
MERGE_JOIN Operator on page 7-42
MERGE_SEMI_JOIN Operator on page 7-44
MERGE_UNION Operator on page 7-45
MultiUnion Operator on page 7-46
NESTED_ANTI_SEMI_JOIN Operator on page 7-46
NESTED_JOIN Operator on page 7-47
NESTED_SEMI_JOIN Operator on page 7-49
NEXTVALUEFOR Operator on page 7-50
NESTED_SEMI_JOIN Operator on page 7-50
ORDERED_HASH_JOIN Operator on page 7-52
TP663851.fm Page 1 Monday, October 17, 2011 11:48 AM