SQL/MX 2.x Query Guide (H06.04+, J06.03+)

SQL/MX Operators
HP NonStop SQL/MX Query Guide—540437-005
7-64
SORT_PARTIAL_AGGR_LEAF Operator
The SORT_GROUPBY operator has one child node. The description field for this
operator contains:
The example of the SORT_GROUPBY operator is based on:
prepare TestQuery33a from
select int64_6,count(*)
from PTAB09
where int64_6 IN (0,2,4,5)
group by int64_6;
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
grouping_columns ....... DETCAT.DETSCH.PTAB09.INT64_6
aggregates ............... count(1 )
SORT_PARTIAL_AGGR_LEAF Operator
Groupby Group
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.
Token Followed by ... Data Type
fragment_id A sequential number assigned to the fragment.
0 is always the master executor and 1 is
reserved for the EXPLAIN plan. Numbers 2 to n
will be ESP or DAM fragments.
integer
parent_frag The fragment_id for the parent fragment of the
current fragment. The value is (none) for the
master executor.
integer
fragment_type Master, ESP, or DP2. text
aggregates Expression of the aggregate function. expr(text)
selection_predicate Expression of the HAVING clause. expr(text)
grouping_columns Expression of the grouping columns. expr(text)