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

The 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
textIndication of whether an optimization for short, simple operations is used.
The value used is returned if this optimization is used.
olt_optimization
textIndicates for short, simple operations whether a further optimization that
reduces the physical size of the plan is used.
olt_opt_lean
textType of insert followed by table or index nameiud_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)Computation of the row to be inserted into each index tablenew_idx_rec_expr
expr(text)Predicate expression specified on the partitioning key. It is displayed only
if partitioning key differs from clustering key
part_key_predicate
textDisplays check constraints on the insert tablecheck_constraint
Many details related to the FILE_SCAN operator also apply to the INSERT operator. See the
“FILE_SCAN Operator” (page 41).
INSERT_VSBB Operator
The INSERT_VSBB operator describes the part of an execution plan that inserts multiple rows
into a table in DAM.
The INSERT_VSBB 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
textType of 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
Operators and Description Fields 35