Neoview Query Guide (R2.2)

NESTED_SEMI_JOIN Operator.................................................................................................37
NESTED_ANTI_SEMI_JOIN Operator......................................................................................38
LEFT_NESTED_JOIN Operator.................................................................................................38
TUPLE_FLOW Operator............................................................................................................39
Merge Joins......................................................................................................................................40
MERGE_JOIN Operator.............................................................................................................40
MERGE_SEMI_JOIN Operator..................................................................................................40
MERGE_ANTI_SEMI_JOIN Operator.......................................................................................41
LEFT_MERGE_JOIN Operator..................................................................................................41
Hybrid Hash Joins...........................................................................................................................41
HYBRID_HASH_JOIN Operator...............................................................................................42
HYBRID_HASH_SEMI_JOIN Operator.....................................................................................42
HYBRID_HASH_ANTI_SEMI_JOIN Operator.........................................................................43
LEFT_HYBRID_HASH_JOIN Operator.....................................................................................43
Ordered Joins...................................................................................................................................44
ORDERED_HASH_JOIN Operator............................................................................................44
ORDERED_HASH_SEMI_JOIN Operator.................................................................................44
ORDERED_HASH_ANTI_SEMI_JOIN.....................................................................................45
LEFT_ORDERED_HASH_JOIN Operator.................................................................................46
ORDER_CROSS_PRODUCT......................................................................................................46
Insert Operators...............................................................................................................................47
INSERT Operator.......................................................................................................................47
INSERT_VSBB Operator............................................................................................................47
SIDETREE_INSERT Operator....................................................................................................48
Update Operators............................................................................................................................48
CURSOR_UPDATE Operator....................................................................................................48
SUBSET_UPDATE Operator......................................................................................................49
UNIQUE_UPDATE Operator.....................................................................................................50
Delete Operators..............................................................................................................................50
CURSOR_DELETE Operator.....................................................................................................50
SUBSET_DELETE Operator.......................................................................................................51
UNIQUE_DELETE Operator.....................................................................................................52
Scan Operators.................................................................................................................................53
FILE_SCAN Operator................................................................................................................53
FILE_SCAN_UNIQUE Operator...............................................................................................54
INDEX_SCAN Operator............................................................................................................54
INDEX_SCAN_UNIQUE Operator...........................................................................................55
Groupby and Sort Operators...........................................................................................................56
HASH_GROUPBY Operator......................................................................................................56
HASH_PARTIAL_GROUPBY_LEAF Operator.........................................................................57
HASH_PARTIAL_GROUPBY_ROOT Operator........................................................................57
SHORTCUT_SCALAR_AGGR Operator...................................................................................58
SORT Operator...........................................................................................................................58
SORT_GROUPBY Operator.......................................................................................................58
SORT_PARTIAL_AGGR_LEAF Operator.................................................................................59
SORT_PARTIAL_AGGR_ROOT Operator................................................................................59
SORT_PARTIAL_GROUPBY_LEAF Operator..........................................................................60
SORT_PARTIAL_GROUPBY_ROOT Operator.........................................................................60
SORT_SCALAR_AGGR Operator.............................................................................................60
TRANSPOSE Operator...............................................................................................................61
Union Operators..............................................................................................................................61
MERGE_UNION Operator........................................................................................................61
Miscellaneous Operators.................................................................................................................62
FIRSTN Operator.......................................................................................................................62
SEQUENCE Operator................................................................................................................62
4 Table of Contents