Neoview Query Guide (R2.2)

The SORT_GROUPBY 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_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
Understanding Joins 59