Neoview Query Guide (R2.2)

Index
B
Binary tree structure, VQP, 28
C
Capturing query execution plans
described, 13
example, 14
historical database, 14
COMPOUNDSTMT operator, 64
CURSOR_DELETE operator, 50
CURSOR_UPDATE operator, 48
D
Delete operators
CURSOR_DELETE, 50
SUBSET_DELETE, 51
Documents, related information, 11
E
ESP (executor server process)
cost associated with, 30
process architecture, 28
ESP_EXCHANGE operator, 34
EXPLAIN operator, 64
Explain statement
capturing query plans, 13
historical explain, 14
operators, 31
F
FILE_SCAN operator, 53
FILE_SCAN_UNIQUE operator, 54
FIRSTN operator, 62
G
Groupby and sort operators
HASH_GROUPBY, 56
HASH_PARTIAL_GROUPBY_LEAF, 57
HASH_PARTIAL_GROUPBY_ROOT, 57
SHORTCUT_SCALAR_AGGR, 58
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
TRANSPOSE, 61
H
Hash join
described, 41
HYBRID_HASH_ANTI_SEMI_JOIN , 43
HYBRID_HASH_JOIN , 42
HYBRID_HASH_SEMI_JOIN, 42
LEFT_HYBRID_HASH_JOIN, 43
LEFT_ORDERED_HASH_JOIN , 46
ORDERED_HASH_ANTI_SEMI_JOIN , 45
ORDERED_HASH_JOIN, 44
ORDERED_HASH_SEMI_JOIN , 44
HASH_GROUPBY operator, 56
HASH_PARTIAL_GROUPBY_LEAF operator, 57
HASH_PARTIAL_GROUPBY_ROOT operator, 57
Help for VQP, 20
HYBRID_HASH_ANTI_SEMI_JOIN operator, 43
HYBRID_HASH_JOIN operator, 42
HYBRID_HASH_SEMI_JOIN operator, 42
I
INDEX_SCAN operator, 54
INDEX_SCAN_UNIQUE operator, 55
INSERT operator, 47
Insert operators
INSERT, 47
INSERT_VSBB, 47
SIDETREE_INSERT, 48
INSERT_VSBB operator, 47
J
Joins
LEFT_NESTED_JOIN , 38
nested, 37
NESTED_ANTI_SEMI_JOIN , 38
NESTED_JOIN , 37
NESTED_SEMI_JOIN, 37
TUPLE_FLOW , 39
understanding, 36
L
LEFT_HYBRID_HASH_JOIN operator, 43
LEFT_MERGE_JOIN operator, 41
LEFT_NESTED_JOIN operator, 38
LEFT_ORDERED_HASH_JOIN operator, 46
M
Merge joins
described, 40
LEFT_MERGE_JOIN , 41
MERGE_ANTI_SEMI_JOIN , 41
MERGE_JOIN , 40
MERGE_SEMI_JOIN , 40
MERGE_ANTI_SEMI_JOIN operator, 41
MERGE_JOIN operator, 40
MERGE_SEMI_JOIN operator, 40
MERGE_UNION operator, 61
N
Nested joins
described, 37
LEFT_NESTED_JOIN , 38
NESTED_ANTI_SEMI_JOIN , 38
67