SQL/MX 3.2.1 Query Guide (H06.26+, J06.15+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
7-69
SHORTCUT_SCALAR_AGGR Operator
sg_currval_sys_host_var
_sys_CV_1950613529239555180_1950613529247292079_1948
362054427974368
sg_increment_hv ........ \:_sys_hostIncrement
sg_cache_size_hv ....... \:_sys_hostVarNextNValues
sg_min_value_hv ........ \:_sys_hostMinValue
sg_max_value_hv ........ \:_sys_hostMaxValue
current_value_from_sg CAT.SCH.S1.CURRENT_VALUE
SHORTCUT_SCALAR_AGGR Operator
Groupby Group
The SHORTCUT_SCALAR_AGGR operator occurs for aggregates without a GROUP
BY clause and returns one row. The description field for this operator contains the
following:
The following is an example of the SHORTCUT_SCALAR_AGGR operator:
prepare TestQuery25 from
select min(f2) from tt22;
DESCRIPTION
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2
aggregates ............... min(DETCAT.DETSCH.II22.F2)
SORT Operator
Sort Group
A SORT operator describes a portion of an execution plan that performs a sort. The
operator for a SORT operator is always SORT.
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 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 WHERE clause. expr(text)
TP663851.fm Page 69 Wednesday, January 30, 2013 5:37 PM