Neoview Query Guide (R2.3, R2.4, R2.5)

Ordered Joins.............................................................................................................................31
ORDERED_HASH_JOIN Operator......................................................................................31
ORDERED_HASH_SEMI_JOIN Operator............................................................................32
ORDERED_HASH_ANTI_SEMI_JOIN................................................................................33
LEFT_ORDERED_HASH_JOIN Operator............................................................................33
ORDER_CROSS_PRODUCT................................................................................................34
Insert Operators...............................................................................................................................34
INSERT Operator.......................................................................................................................34
INSERT_VSBB Operator............................................................................................................35
SIDETREE_INSERT Operator....................................................................................................36
Update Operators............................................................................................................................36
CURSOR_UPDATE Operator....................................................................................................36
SUBSET_UPDATE Operator......................................................................................................37
UNIQUE_UPDATE Operator.....................................................................................................38
Delete Operators..............................................................................................................................39
CURSOR_DELETE Operator.....................................................................................................39
SUBSET_DELETE Operator.......................................................................................................39
UNIQUE_DELETE Operator.....................................................................................................40
Scan Operators.................................................................................................................................41
FILE_SCAN Operator................................................................................................................41
FILE_SCAN_UNIQUE Operator...............................................................................................42
INDEX_SCAN Operator............................................................................................................43
INDEX_SCAN_UNIQUE Operator...........................................................................................44
Groupby and Sort Operators...........................................................................................................45
HASH_GROUPBY Operator......................................................................................................45
HASH_PARTIAL_GROUPBY_LEAF Operator.........................................................................46
HASH_PARTIAL_GROUPBY_ROOT Operator........................................................................46
SHORTCUT_SCALAR_AGGR Operator...................................................................................47
SORT Operator...........................................................................................................................47
SORT_GROUPBY Operator.......................................................................................................47
SORT_PARTIAL_AGGR_LEAF Operator.................................................................................48
SORT_PARTIAL_AGGR_ROOT Operator................................................................................48
SORT_PARTIAL_GROUPBY_LEAF Operator..........................................................................48
SORT_PARTIAL_GROUPBY_ROOT Operator.........................................................................49
SORT_SCALAR_AGGR Operator.............................................................................................49
TRANSPOSE Operator...............................................................................................................50
Union Operators..............................................................................................................................50
MERGE_UNION Operator........................................................................................................50
Miscellaneous Operators.................................................................................................................51
CALL Operator..........................................................................................................................51
FIRSTN Operator.......................................................................................................................51
SEQUENCE Operator................................................................................................................51
TUPLELIST Operator.................................................................................................................52
VALUES Operator......................................................................................................................52
Operators Appearing Infrequently or Not At All...........................................................................53
COMPOUNDSTMT Operator....................................................................................................53
EXPLAIN Operator....................................................................................................................53
PACK Operator..........................................................................................................................53
SAMPLE Operator.....................................................................................................................54
UNPACK Operator....................................................................................................................54
Index.................................................................................................................................55
4 Table of Contents