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

The PARTITION_ACCESS operator has one child operator. 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
integerBuffer size for messages between PARTITION_ACCESS operator
and DAM
buffer_size
integerLength of the record that is returned by DAMrecord_length
integerOne of the following: Size of packed plan fragment in 1 KB units.
Size of unpacked plan fragment in 1 KB units. Heap (used for
dynamically allocating entities such as queue entries and
diagnostic areas) size in 1 KB units. Total size in 1 KB units.
space_usage
textType of top partitioning and contains summary information about
the parallel plan
parent_partitioning_function
textType of bottom partitioning and contains summary information
about the parallel plan
child_partitioning_function
textAssociates each process at the bottom to a CPUbottom_node_map
expr(text)Predicates used to determine the begin key, which might include
or exclude the specified key
begin_key_preds (incl | excl)
expr(text)Boolean expression indicating whether the begin key is excluded
from the key range (in cases where this is determined dynamically)
begin_key_exclusion_expr
expr(text)Predicates used to determine the end key, which might include
or exclude the specified key
end_key_preds (incl | excl)
expr(text)Boolean expression indicating whether the end key is excluded
from the key range (in cases where this is determined dynamically)
end_key_exclusion_expr
expr(text)Expression used to calculate the start partition number (appears
instead of begin_key_preds and begin_key_exclusion_expr)
begin_part_no_expr
expr(text)Expression used to calculate the end partition number (appears
instead of end_key_preds and end_key_exclusion_expr)
end_part_no_expr
textExpression used by SPLIT_TOP or PARTITION_ACCESS to
compute the begin_part_no_expr.
begin_part_selection_expr
textExpression used by SPLIT_TOP or PARTITION_ACCESS to
compute the end_part_no_expr.
end_part_selection_expr
textExpression used to generate the seed value. Appears only when
inserting into a table with an IDENTITY column.
sequence_init_expr
textExpression used to generate values for the IDENTITY column.
Values will be in sequence for this INSERT statement. Appears
only when inserting into a table with an IDENTITY column.
sequence_generation_expr
SPLIT_TOP Operator
The SPLIT_TOP operator describes a portion of an execution plan for a file system interface in
which requests to DAM occur with some level of parallel processing. No startup costs are
Operators and Description Fields 23