Neoview Query Guide (R2.2)

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
TRANSPOSE, 61
SORT operator, 58
SORT_GROUPBY operator, 58
SORT_PARTIAL_AGGR_LEAF operator, 59
SORT_PARTIAL_AGGR_ROOT operator, 59
SORT_PARTIAL_GROUPBY_LEAF operator, 60
SORT_PARTIAL_GROUPBY_ROOT operator, 60
SORT_SCALAR_AGGR operator, 60
SPLIT_TOP operator, 29, 36
SUBSET_DELETE operator, 51
SUBSET_UPDATE operator, 49
T
TRANSPOSE operator, 61
TUPLE_FLOW operator, 39
TUPLELIST operator, 63
U
UNIQUE_UPDATE operator, 50
UNPACK operator, 63
Update operators
CURSOR_UPDATE, 48
SUBSET_UPDATE , 49
UNIQUE_UPDATE , 50
V
VALUES operator, 63
Visual Query Planner
and EXPLAIN, 19
connecting to ODBC with, 20
considerations, 21
cost details, 26
description details, 26
downloading from web, 19
logical tree form, 27
node details, 25
ODBC data source, 20
online help, 20
operator icons, 22
process boundaries, 29
purpose of, 19, 20
requirements, 20
saving plans, 22
starting, 20
summary detail of, 21
toolbar, 23
using, 20
69