SQL/MX 3.2 Query Guide (H06.25+, J06.14+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.2 Query Guide—663851-002
7-66
SHORTCUT_SCALAR_AGGR Operator
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:
sg_cache_initial The initial cache value that influences the
default adaptive cache. The cache value
dynamically changes at runtime based on the
following CQD settings:
SEQUENCE_GENERATOR_CACHE_INITIAL
value is multiplied by the
SEQUENCE_GENERATOR_CACHE_INCRE
MENT value, and is compared with
SEQUENCE_GENERATOR_CACHE_MAXIM
UM.
int64
sg_cache_increment The multiplier that influences the default
adaptive cache. For details, see the
explanation for sg_cache_initial token.
int64
sg_cache_maximum The maximum value that influences the default
adaptive cache. For details, see the
explanation for sg_cache_initial token.
int 64
sg_type The type of sequence generator, EXTERNAL
or INTERNAL.
text
sg_increment_hv The expression contains the
sg_increment_option value. It is sent to
the NEXTVALUEFOR operator along with
sg_cache_size_hv and
current_value_from_sg to calculate the
next value.
expr(text)
sg_cache_size_hv The expression is used to calculate the
sequence generator cache size.
expr(text)
current_value_from_sg The expression holds the current value of the
sequence generator. Current value is the next
value available from the sequence generator.
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 of the current
fragment. The value is (none) for the master
executor.
integer
TP663851.fm Page 66 Thursday, August 2, 2012 4:47 PM