Neoview Query Guide (R2.2)

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.
The SORT_PARTIAL_GROUPBY_LEAF operator has one child operator. 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 grouping columnsgrouping_columns
expr(text)Expression of the aggregate functionaggregates
expr(text)Expression of the HAVING clauseselection_predicates
SORT_PARTIAL_GROUPBY_ROOT Operator
The SORT_PARTIAL_GROUPBY_ROOT operator works together as a pair with the
SORT_PARTIAL_GROUPBY_LEAF operator. The SORT_PARTIAL_GROUPBY_ROOT operator
finalizes the group by at the ESP level.
The SORT_PARTIAL_GROUPBY_ROOT operator has one child operator. 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 grouping columnsgrouping_columns
expr(text)Expression of the aggregate functionaggregates
expr(text)Expression of the HAVING clauseselection_predicates
SORT_SCALAR_AGGR Operator
The SORT_SCALAR_AGGR operator occurs for aggregates without a GROUP BY clause. It
returns one row. 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
60 Query Plan Operators