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

SQL/MX Operators
HP NonStop SQL/MX Query Guide—540437-005
7-65
SORT_PARTIAL_AGGR_ROOT Operator
The description field for this operator contains:
The example of the SORT_PARTIAL_AGGR_LEAF operator is based on:
prepare TestQuery17 from
select T03.char_100
from PTAB03 T03
where T03.char_100 =
(Select min(T00.char_10)
from PTAB00 T00);
DESCRIPTION
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2
aggregates ............... min(DETCAT.DETSCH.PTAB00.CHAR_10)
SORT_PARTIAL_AGGR_ROOT Operator
Groupby Group
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:
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)
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)