Neoview Query Guide (R2.2)

Data TypeToken DescriptionToken
textIndicates for short, simple operations whether a further optimization that
reduces the physical size of the plan is used.
olt_opt_lean
expr(text)Type of update followed by table or index nameiud_type
textPresent only if partition name is specified in the UPDATE 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)Expression of the begin key predicatesbegin_key
expr(text)Expression of the begin key predicates on indexindex_begin_key
expr(text)Predicate expression specified on partitioning key. It is displayed only if
partitioning key differs from clustering key
part_key_predicate
textCheck constraints on the update tablecheck_constraint
SUBSET_UPDATE Operator
The SUBSET_UPDATE operator describes a portion of an execution plan that details how a
certain access path is scanned: it updates more than one row. A subset operation performs the
read and update in a combined operation. This operation differs from CURSOR_UPDATE, which
performs the read and update in separate operations. The CURSOR_UPDATE operation also
involves more messages.
This 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
expr(text)subset_update followed by the table nameiud_type
text
Displays volatile and is present only if the update is to a volatile table.
object_type
textPresent only if partition name is specified in the UPDATE statement.
Returns the name of the partition.
partition_name
expr(text)Computation of the row to be updatednew_rec_expr
expr(text)Computation of the row to be inserted into each index tablenew_idx_rec_expr
expr(text)Expression specified on WHERE clausepredicate
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 predicates on the clustering key columns of
the table or index
begin_key
expr(text)Expression of the begin key predicates on indexindex_begin_key
expr(text)Expression of the end key predicates on the clustering key columns of the
table or index
end_key
expr(text)Expression of the end key predicates on the indexindex_end_key
textCheck constraints on the update tablecheck_constraint
Understanding Joins 49