Neoview Query Guide (R2.3, R2.4, R2.5)
Index
C
CALL operator, 51
Capturing query execution plans
described, 12
example, 13
historical database, 12
COMPOUNDSTMT operator, 53
CURSOR_DELETE operator, 39
CURSOR_UPDATE operator, 36
D
Delete operators
CURSOR_DELETE, 39
SUBSET_DELETE, 39
Documents, related information, 7
E
ESP (executor server process)
cost associated with, 20
ESP_EXCHANGE operator, 21
EXPLAIN operator, 53
Explain statement
capturing query plans, 12
historical explain, 12
operators, 17
F
FILE_SCAN operator, 41
FILE_SCAN_UNIQUE operator, 42
FIRSTN operator, 51
G
Groupby and sort 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
SORT_SCALAR_AGGR, 49
TRANSPOSE, 50
H
Hash join
described, 29
HYBRID_HASH_ANTI_SEMI_JOIN , 30
HYBRID_HASH_JOIN , 29
HYBRID_HASH_SEMI_JOIN, 30
LEFT_HYBRID_HASH_JOIN, 31
LEFT_ORDERED_HASH_JOIN , 33
ORDERED_HASH_ANTI_SEMI_JOIN , 33
ORDERED_HASH_JOIN, 31
ORDERED_HASH_SEMI_JOIN , 32
HASH_GROUPBY operator, 45
HASH_PARTIAL_GROUPBY_LEAF operator, 46
HASH_PARTIAL_GROUPBY_ROOT operator, 46
HYBRID_HASH_ANTI_SEMI_JOIN operator, 30
HYBRID_HASH_JOIN operator, 29
HYBRID_HASH_SEMI_JOIN operator, 30
I
INDEX_SCAN operator, 43
INDEX_SCAN_UNIQUE operator, 44
INSERT operator, 34
Insert operators
INSERT, 34
INSERT_VSBB, 35
SIDETREE_INSERT, 36
INSERT_VSBB operator, 35
J
Joins
LEFT_NESTED_JOIN , 26
nested, 24
NESTED_ANTI_SEMI_JOIN , 26
NESTED_JOIN , 25
NESTED_SEMI_JOIN, 25
TUPLE_FLOW , 27
understanding, 24
L
LEFT_HYBRID_HASH_JOIN operator, 31
LEFT_MERGE_JOIN operator, 29
LEFT_NESTED_JOIN operator, 26
LEFT_ORDERED_HASH_JOIN operator, 33
M
Merge joins
described, 27
LEFT_MERGE_JOIN , 29
MERGE_ANTI_SEMI_JOIN , 28
MERGE_JOIN , 27
MERGE_SEMI_JOIN , 28
MERGE_ANTI_SEMI_JOIN operator, 28
MERGE_JOIN operator, 27
MERGE_SEMI_JOIN operator, 28
MERGE_UNION operator, 50
N
Nested joins
described, 24
LEFT_NESTED_JOIN , 26
NESTED_ANTI_SEMI_JOIN , 26
NESTED_JOIN , 25
NESTED_SEMI_JOIN , 25
TUPLE_FLOW , 27
NESTED_ANTI_SEMI_JOIN operator, 26
55