Neoview Query Guide (R2.3, R2.4, R2.5)

Data TypeToken DescriptionToken
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 a simple scan operation is used.
The value used is returned if this optimization is used.
fast_scan
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
textPresent only if partition name is specified in the statement. Returns the name
of the partition.
partition_name
expr(text)Columns used as the primary keykey_columns
expr(text)Any predicate expression that is not a key predicate evaluated by the executor
in DAM
executor_predicates
expr(text)Disjunct key predicates used by MDAMmdam_disjunct
expr(text)Predicate expression specified on partitioning key. It is displayed only if
partitioning key differs from clustering key.
part_key_predicate
expr(text)Expression of the begin key predicatebegin_key
expr(text)Expression of the end key predicateend_key
FILE_SCAN_UNIQUE Operator
The FILE_SCAN_UNIQUE operator describes a portion of an execution plan where you are
scanning for a unique key value. It selects zero or one row.
The FILE_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
textIndicates 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
42 Query Plan Operators