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-67
The description field for the operator contains the
following:
The description field for the operator contains the following:
Token Followed by ... Data Type
max_card_est Cardinality estimate for this operator. integer
fragment_id A sequential number assigned to the fragment.
0 is 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 ESP. text
sg_start_with_option The sequence generator option that specifies
the START WITH value.
int64
sg_increment_option The INCREMENT-BY option of the sequence
generator. The next value is obtained by
adding this value to current value.
int64
sg_maximum_option The sequence generator option that specifies
the highest value for the sequence.
int64
sg_minimum_option The sequence generator option that specifies
the lowest value for the sequence.
int64
sg_datatype The sequence generator data type. int64
sg_cycle_option The sequence generator option that specifies
whether the sequence generator values can
be cycled. The option values are CYCLE or
NO CYCLE.
text
sg_cache The user defined sequence generator cache
value. The default is 0. If the value is greater
than 0, each request gets the user specified
number of values for the cache.
int64
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
TP663851.fm Page 67 Wednesday, January 30, 2013 5:37 PM