Neoview Query Guide (R2.2)

The INDEX_SCAN_UNIQUE operator has no child operators. The description field for this
operator contains:
Data TypeToken DescriptionToken
integerA sequential number assigned to the fragment. 0 is always master
executor and 1 is reserved for the Explain plan. Numbers 2 to n will be
ESP or DAM fragments.
fragment_id
integerThe fragment_id for the parent fragment of the current fragment. Value
is (none) for master executor.
parent_frag
textmaster, ESP, or DAMfragment_type
textIndicates whether an optimization for short, simple operations is used.
The value used is returned if this optimization is used.
olt_optimization
Indicates whether a further optimization for short, simple operations
is used. The value used is returned if this optimization is used.
olt_opt_lean
text{full scan | subset scan | unique access} of {index
index-name(table-name)| table}table-name
scan_type
textPresent only if the update is to a volatile table. Returns the text
volatile in this case.
object_type
textThe lock mode specified: shared, exclusive, not specified, or unknownlock_mode
textThe access specified: read committed, read uncommitted, stable, skip
conflict, serializable, not specified, or unknown
access_mode
integerEstimate of the number of columns to be returnedcolumns_retrieved
textIndication of whether an optimization for returning data from DAM is
used. The value used is returned if this optimization is used.
fast_replydata_move
textIndication of whether an optimization for returning data from DAM is
used. The value used is returned if this optimization is used.
fast_scan
textPresent only if partition name is specified in the statementpartition_name
expr(text)Columns used as the primary keykey_columns
expr(text)Any predicate that is not a key predicate evaluated by the executor in
DAM
executor_predicates
textPredicate expression specified on the partitioning key. Displayed only
if partitioning key differs from clustering key.
part_key_predicate
expr(text)Expression of the begin key predicate; same as the end key predicatebegin_key
expr(text)Expression of the end key predicate; same as the begin key predicateend_key
text
Present if MDAM is used for the scan. Value used
mdam
Groupby and Sort Operators
The SORT prefix in the operators such as SORT_PARTIAL_AGGR_ROOT indicate that the
operation requires that the data is sorted. Although this sort might require a SORT operator, it
can be satisfied by the natural order of the data stream.
HASH_GROUPBY Operator
The HASH_GROUPBY operator describes a portion of an execution plan that affects a group.
The group values are computed by hashing individual rows into a hash table. When a new row
is received, the executor hashes to the hash table and performs the aggregate in the hash table.
56 Query Plan Operators