Neoview Query Guide (R2.2)

Insert Operators
INSERT Operator
The INSERT operator describes the part of an execution plan that inserts a new row into a table.
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
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
Understanding Joins 47