Neoview Query Guide (R2.2)

The HASH_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
SHORTCUT_SCALAR_AGGR Operator
The SHORTCUT_SCALAR_AGGR operator occurs for aggregates without a GROUP BY clause
and 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
textmaster, ESP, or DAMfragment_type
expr(text)Expression of the aggregate functionaggregates
expr(text)Expression of the WHERE clauseselection_predicates
SORT Operator
A SORT operator describes a portion of an execution plan that performs a sort. Sorts are blocking
operations; that is, a plan cannot proceed until the sort is finished. If a SORT deals with too much
data, the rest of the plan cannot continue until the sort is complete. This blocking can hold up
the plan and can lead to a stalled query or an overflow issue.
The SORT 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 describing sort keyssort_key
SORT_GROUPBY Operator
The SORT_GROUPBY operator describes a portion of an execution plan that affects a group.
58 Query Plan Operators