Neoview Query Guide (R2.2)
NESTED_JOIN , 37
NESTED_SEMI_JOIN , 37
TUPLE_FLOW , 39
NESTED_ANTI_SEMI_JOIN operator, 38
NESTED_JOIN operator, 37
NESTED_SEMI_JOIN operator, 37
O
Operators
COMPOUNDSTMT , 64
CURSOR_DELETE, 50
CURSOR_UPDATE, 48
described, 31
ESP_EXCHANGE, 34
EXPLAIN, 64
FILE_SCAN, 53
FILE_SCAN_UNIQUE, 54
FIRSTN operator, 62
HASH_GROUPBY, 56
HASH_PARTIAL_GROUPBY_LEAF, 57
HASH_PARTIAL_GROUPBY_ROOT, 57
HYBRID_HASH_ANTI_SEMI_JOIN, 43
HYBRID_HASH_JOIN, 42
HYBRID_HASH_SEMI_JOIN, 42
INDEX_SCAN, 54
INDEX_SCAN_UNIQUE, 55
INSERT, 47
INSERT_VSBB , 47
LEFT_HYBRID_HASH_JOIN, 43
LEFT_MERGE_JOIN, 41
LEFT_NESTED_JOIN , 38
LEFT_ORDERED_HASH_JOIN, 46
MERGE_ANTI_SEMI_JOIN, 41
MERGE_JOIN, 40
MERGE_SEMI_JOIN, 40
MERGE_UNION, 61
NESTED_ANTI_SEMI_JOIN , 38
NESTED_JOIN, 37
NESTED_SEMI_JOIN , 37
ORDERED_HASH_ANTI_SEMI_JOIN, 45
ORDERED_HASH_JOIN, 44
ORDERED_HASH_SEMI_JOIN , 44
PACK, 64
PARTITION_ACCESS , 35
ROOT , 33
SAMPLE, 65
SEQUENCE, 62
SHORTCUT_SCALAR_AGGR, 58
SIDETREE_INSERT, 48
SORT, 58
SORT_GROUPBY , 58
SORT_PARTIAL_AGGR_LEAF , 59
SORT_PARTIAL_AGGR_ROOT , 59
SORT_PARTIAL_GROUPBY_LEAF , 60
SORT_PARTIAL_GROUPBY_ROOT, 60
SORT_SCALAR_AGGR, 60
SPLIT_TOP, 36
SUBSET_DELETE, 51
SUBSET_UPDATE, 49
TRANSPOSE, 61
TUPLE_FLOW , 39
TUPLELIST, 63
UNIQUE_UPDATE, 50
UNPACK, 63
VALUES, 63
Ordered hash joins
LEFT_ORDERED_HASH_JOIN , 46
ORDERED_HASH_ANTI_SEMI_JOIN , 45
ORDERED_HASH_JOIN , 44
ORDERED_HASH_SEMI_JOIN , 44
ORDERED_HASH_ANTI_SEMI_JOIN operator, 45
ORDERED_HASH_JOIN operator, 44
ORDERED_HASH_SEMI_JOIN operator, 44
P
PACK operator, 64
PARTITION_ACCESS operator, 35
Partitioned parallelism
DAM process, 30
ESP process, 30
Process architecture
DAM process, 28
described, 28
ESP process, 28
MXCMP process, 28
MXOSRVR process, 28
process boundaries, 29
Process boundaries
discussed, 32
ESP_EXCHANGE operator, 33
PARTITION_ACCESS operator, 33
ROOT operator, 33
Q
Query execution plan
capturing, 13
defined, 13
logical tree form, 27
saving with VQP, 22
Query plan operators, 31
Query, process architecture, 28
R
ROOT operator, 33
S
SAMPLE operator, 65
Scan operators
FILE_SCAN, 53
FILE_SCAN_UNIQUE, 54
INDEX_SCAN , 54
INDEX_SCAN_UNIQUE, 55
SEQUENCE operator, 62
SHORTCUT_SCALAR_AGGR operator, 58
SIDETREE_INSERT operator, 48
Sort and groupby operators
HASH_GROUPBY, 56
HASH_PARTIAL_GROUPBY_LEAF, 57
68 Index