Neoview Query Guide (R2.2)

Data TypeToken DescriptionToken
expr(text)Predicate expression specified on the partitioning key.
Displayed only if partitioning key differs from clustering
key
part_key_predicate
textDisplays check constraints on the insert tablecheck_constraint
SIDETREE_INSERT Operator
The SIDETREE_INSERT operator describes that part of an execution plan that inserts entire
blocks of rows into a table in DAM. This operator can only be used on empty tables when the
table is unaudited.
The SIDETREE_INSERT 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
textsidetree_insert followed by table nameiud_type
text
Value volatile is present only if the insert is into a volatile table.
object_type
textPresent only if partition name is specified in the INSERT statement. Returns
the name of the partition.
partition_name
expr(text)Computation of the row to be insertednew_rec_expr
expr(text)Predicate expression specified on the partitioning key. Displayed only if
partitioning key differs from clustering key
part_key_predicate
textDisplays check constraints on the insert tablecheck_constraint
Update Operators
CURSOR_UPDATE Operator
The CURSOR_UPDATE operator describes a portion of an execution plan that works on one
row only. The CURSOR_UPDATE operation is performed by first retrieving rows from the table
and then updating each row that is required. This operation differs from SUBSET_UPDATE, in
which the read and update are performed in a combined operation.
The CURSOR_UPDATE 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.
Value is used if this optimization is used.
olt_optimization
48 Query Plan Operators