Neoview Query Guide (R2.2)

Data TypeToken DescriptionToken
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)Expression describing sort keysmerged_order
No meaning; token to be removed in a future releasebottom_partition_input_values
PARTITION_ACCESS Operator
The PARTITION_ACCESS operator describes a portion of an execution plan for a file system
interface in which requests are made to DAM. This operator represents the DAM process
boundary. This operator and all operators subordinate to it execute inside a DAM. The DAM
process runs in parallel to the PARTITION_ACCESS (no-waited interface). For more information
about exchange operators, see Chapter 2 (page 19).
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
Operators and Description Fields 35