Neoview Query Guide (R2.3, R2.4, R2.5)

Data TypeToken DescriptionToken
expr(text)Expression of the grouping columnsgrouping_columns
expr(text)Expression of the aggregate functionaggregates
expr(text)Expression of the HAVING clauseselection_predicates
SORT_PARTIAL_AGGR_LEAF Operator
The SORT_PARTIAL_AGGR_LEAF operator executes a partial group by operation as close to
where the data is read as is cost effective. This strategy reduces the amount of data that must be
redistributed for a query. The operator must always be accompanied by a
SORT_PARTIAL_AGGR_ROOT operator above it in the tree, which finalizes the query.
This operator consists of a one-row aggregate without standard aggregate functions (SUM, MIN,
MAX, and so on). The leaf portion occurs in the executor portion of DAM. The description field
for this operator contains:
Data TypeToken DescriptionToken
integerA sequential number assigned to the fragment. 0 is always master executor
and 1 is reserved for the Explain plan. Numbers 2 to n will be ESP or DAM
fragments.
fragment_id
integerThe fragment_id for the parent fragment of the current fragment. Value is
(none) for master executor.
parent_frag
textmaster, ESP, or DAMfragment_type
expr(text)Expression of the aggregate functionaggregates
SORT_PARTIAL_AGGR_ROOT Operator
The SORT_PARTIAL_AGGR_ROOT operator works together as a pair with the
SORT_PARTIAL_AGGR_LEAF operator. The SORT_PARTIAL_AGGR_ROOT operator finalizes
the group by at the ESP level. This operator consists of a one-row aggregate without standard
aggregate functions (SUM, MIN, MAX, and so on). The root portion occurs in the root. The
description field for this operator contains:
Data TypeToken DescriptionToken
integerA sequential number assigned to the fragment. 0 is always master executor
and 1 is reserved for the Explain plan. Numbers 2 to n will be ESP or DAM
fragments.
fragment_id
integerThe fragment_id for the parent fragment of the current fragment. Value is
(none) for master executor.
parent_frag
textmaster, ESP, or DAMfragment_type
expr(text)Expression of the aggregate functionaggregates
SORT_PARTIAL_GROUPBY_LEAF Operator
The SORT_PARTIAL_GROUPBY_LEAF operator executes a partial group by as close to where
the data is read as is cost effective. This strategy reduces the amount of data that must be
redistributed for a query. The operator must always be accompanied by a
SORT_PARTIAL_GROUPBY_ROOT operator above it in the tree, which finalizes the query.
48 Query Plan Operators