Neoview Query Guide (R2.3, R2.4, R2.5)
NESTED_JOIN operator, 25
NESTED_SEMI_JOIN operator, 25
O
Operators
CALL , 51
COMPOUNDSTMT , 53
CURSOR_DELETE, 39
CURSOR_UPDATE, 36
described, 17
ESP_EXCHANGE, 21
EXPLAIN, 53
FILE_SCAN, 41
FILE_SCAN_UNIQUE, 42
FIRSTN operator, 51
HASH_GROUPBY, 45
HASH_PARTIAL_GROUPBY_LEAF, 46
HASH_PARTIAL_GROUPBY_ROOT, 46
HYBRID_HASH_ANTI_SEMI_JOIN, 30
HYBRID_HASH_JOIN, 29
HYBRID_HASH_SEMI_JOIN, 30
INDEX_SCAN, 43
INDEX_SCAN_UNIQUE, 44
INSERT, 34
INSERT_VSBB , 35
LEFT_HYBRID_HASH_JOIN, 31
LEFT_MERGE_JOIN, 29
LEFT_NESTED_JOIN , 26
LEFT_ORDERED_HASH_JOIN, 33
MERGE_ANTI_SEMI_JOIN, 28
MERGE_JOIN, 27
MERGE_SEMI_JOIN, 28
MERGE_UNION, 50
NESTED_ANTI_SEMI_JOIN , 26
NESTED_JOIN, 25
NESTED_SEMI_JOIN , 25
ORDERED_HASH_ANTI_SEMI_JOIN, 33
ORDERED_HASH_JOIN, 31
ORDERED_HASH_SEMI_JOIN , 32
PACK, 53
PARTITION_ACCESS , 22
ROOT , 20
SAMPLE, 54
SEQUENCE, 51
SHORTCUT_SCALAR_AGGR, 47
SIDETREE_INSERT, 36
SORT, 47
SORT_GROUPBY , 47
SORT_PARTIAL_AGGR_LEAF , 48
SORT_PARTIAL_AGGR_ROOT , 48
SORT_PARTIAL_GROUPBY_LEAF , 48
SORT_PARTIAL_GROUPBY_ROOT, 49
SORT_SCALAR_AGGR, 49
SPLIT_TOP, 23
SUBSET_DELETE, 39
SUBSET_UPDATE, 37
TRANSPOSE, 50
TUPLE_FLOW , 27
TUPLELIST, 52
UNIQUE_UPDATE, 38
UNPACK, 54
VALUES, 52
Ordered hash joins
LEFT_ORDERED_HASH_JOIN , 33
ORDERED_HASH_ANTI_SEMI_JOIN , 33
ORDERED_HASH_JOIN , 31
ORDERED_HASH_SEMI_JOIN , 32
ORDERED_HASH_ANTI_SEMI_JOIN operator, 33
ORDERED_HASH_JOIN operator, 31
ORDERED_HASH_SEMI_JOIN operator, 32
P
PACK operator, 53
PARTITION_ACCESS operator, 22
Partitioned parallelism
DAM process, 20
ESP process, 20
Process boundaries
discussed, 18
ESP_EXCHANGE operator, 19
PARTITION_ACCESS operator, 19
ROOT operator, 19
Q
Query execution plan
capturing, 12
defined, 11
Query plan operators, 17
R
ROOT operator, 20
S
SAMPLE operator, 54
Scan operators
FILE_SCAN, 41
FILE_SCAN_UNIQUE, 42
INDEX_SCAN , 43
INDEX_SCAN_UNIQUE, 44
SEQUENCE operator, 51
SHORTCUT_SCALAR_AGGR operator, 47
SIDETREE_INSERT operator, 36
Sort and groupby operators
HASH_GROUPBY, 45
HASH_PARTIAL_GROUPBY_LEAF, 46
HASH_PARTIAL_GROUPBY_ROOT, 46
SHORTCUT_SCALAR_AGGR, 47
SORT, 47
SORT_GROUPBY, 47
SORT_PARTIAL_AGGR_LEAF, 48
SORT_PARTIAL_AGGR_ROOT, 48
SORT_PARTIAL_GROUPBY_LEAF, 48
SORT_PARTIAL_GROUPBY_ROOT, 49
TRANSPOSE, 50
SORT operator, 47
SORT_GROUPBY operator, 47
SORT_PARTIAL_AGGR_LEAF operator, 48
SORT_PARTIAL_AGGR_ROOT operator, 48
56 Index