SQL/MX 3.1 Query Guide (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
iv
7. SQL/MX Operators
CURSOR_DELETE Operator 7-8
CURSOR_UPDATE Operator 7-9
ESP_ACCESS Operator 7-11
ESP_EXCHANGE Operator 7-12
EXPLAIN Operator 7-16
EXPR Operator 7-16
EXPLAIN_CMD Operator 7-17
FILE_SCAN Operator 7-17
FILE_SCAN_UNIQUE Operator 7-19
FirstN Operator
7-22
HASH_GROUPBY Operator
7-22
HASH_PARTIAL_GROUPBY_LEAF Operator 7-24
HASH_PARTIAL_GROUPBY_ROOT Operator 7-25
HYBRID_HASH_ANTI_SEMI_JOIN Operator 7-26
HYBRID_HASH_JOIN Operator 7-27
HYBRID_HASH_SEMI_JOIN Operator 7-28
INDEX_SCAN Operator 7-29
INDEX_SCAN_UNIQUE Operator 7-31
INSERT Operator 7-33
INSERT_VSBB Operator 7-34
LEFT_HYBRID_HASH_JOIN Operator 7-35
LEFT_MERGE_JOIN Operator 7-36
LEFT_NESTED_JOIN Operator 7-38
LEFT_ORDERED_HASH_JOIN Operator 7-39
MATERIALIZE Operator
7-40
MERGE_ANTI_SEMI_JOIN Operator 7-41
MERGE_JOIN Operator
7-42
MERGE_SEMI_JOIN Operator
7-44
MERGE_UNION Operator
7-45
MultiUnion Operator 7-46
NESTED_ANTI_SEMI_JOIN Operator
7-46
NESTED_JOIN Operator
7-47
NESTED_SEMI_JOIN Operator 7-49
NEXTVALUEFOR Operator 7-50
NESTED_SEMI_JOIN Operator 7-50
7-50
ORDERED_HASH_JOIN Operator 7-52
ORDERED_HASH_SEMI_JOIN Operator 7-53
ORDERED_UNION Operator 7-54
TP663851.fm Page iv Monday, October 17, 2011 11:48 AM