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

Data TypeToken DescriptionToken
intThe transaction autoabort interval. -1 means autoabort interval as
configured for the entire system. 0 means the transaction never auto
aborts. Any other value means the number of seconds after which the
transaction will auto abort. Legal values are in the range 20 to 21474836
seconds.
xn_autoabort_interval
intVersion number associated with the plan. Value is 2020 for plans
generated by the Neoview SQL R2.2compiler.
plan_version
expr(text)Expression of the SELECT list columnsselect_list
expr(text)Expression containing list of input variables (params)input_variables
expr(text)Expression containing list of sort keysorder_by
expr(text)The update column specification of an updatable cursor declarationupdate_col
text
The ESP allocation map for the ith fragment in the query plan. The
fragment ID is indicated for each operator in the EXPLAIN output.
esp_i_node_map
intThe value used by the compiler for the ESP placement for this query.affinity_value
ESP_EXCHANGE Operator
An ESP_EXCHANGE operator describes a portion of an execution plan that redistributes the
input data stream. This operator serves as a process boundary and represents an interface between
ESPs, between the master executor and one or more ESPs, or between an ESP process and a DAM
process. This operator and all operators subordinate to it execute inside an ESP until another
process boundary is reached. ESPs receive input rows from “child” processes and send output
rows to “parent” processes. The number of ESP processes associated with a specific
ESP_EXCHANGE operator equals the number of ESP “child processes” indicated in the operator.
For more information about exchange operators, see the Neoview Performance Analyzer online
help.
The ESP_EXCHANGE 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
integerSize of message bufferbuffer_size
integerNumber of bytes in the record sentrecord_length
integerIndicates the number of processes that the ESPs in this
ESP_EXCHANGE operator communicate with, either
additional ESPs (as indicated by another ESP_EXCHANGE
operator) or the master process.
parent_processes
integerIndicates the number of processes that supply the ESPs of an
operator with rows. The number of ROWS_OUT (also called
CARDINALITY) from the operator that supplies the
ESP_EXCHANGE operator with data indicates how many
rows the ESP_EXCHANGE operator is expected to receive.
child_processes
Operators and Description Fields 21