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

Contents
HP NonStop SQL/MX Query Guide—640323-001
iv
7. SQL/MX Operators (continued)
7. SQL/MX Operators (continued)
FILE_SCAN Operator 7-15
FILE_SCAN_UNIQUE Operator 7-17
FirstN Operator 7-20
HASH_GROUPBY Operator 7-20
HASH_PARTIAL_GROUPBY_LEAF Operator 7-22
HASH_PARTIAL_GROUPBY_ROOT Operator 7-23
HYBRID_HASH_ANTI_SEMI_JOIN Operator 7-24
HYBRID_HASH_JOIN Operator 7-25
HYBRID_HASH_SEMI_JOIN Operator 7-26
INDEX_SCAN Operator 7-27
INDEX_SCAN_UNIQUE Operator 7-29
INSERT Operator 7-31
INSERT_VSBB Operator 7-32
LEFT_HYBRID_HASH_JOIN Operator 7-33
LEFT_MERGE_JOIN Operator 7-34
LEFT_NESTED_JOIN Operator 7-36
LEFT_ORDERED_HASH_JOIN Operator 7-37
MATERIALIZE Operator 7-38
MERGE_ANTI_SEMI_JOIN Operator 7-39
MERGE_JOIN Operator 7-40
MERGE_SEMI_JOIN Operator 7-42
MERGE_UNION Operator 7-43
MultiUnion Operator 7-44
NESTED_ANTI_SEMI_JOIN Operator 7-44
NESTED_JOIN Operator 7-45
NESTED_SEMI_JOIN Operator 7-47
ORDERED_HASH_ANTI_SEMI_JOIN 7-48
ORDERED_HASH_JOIN Operator 7-49
ORDERED_HASH_SEMI_JOIN Operator 7-50
ORDERED_UNION Operator 7-52
PACK Operator 7-53
PARTITION_ACCESS Operator 7-54
ROOT Operator 7-56
SAMPLE Operator 7-58
SAMPLE_FILE_SCAN Operator 7-59
SEQUENCE Operator 7-60
SHORTCUT_SCALAR_AGGR Operator 7-62
SORT Operator 7-62