Neoview SQL Reference Manual (R2.3)

A node of an operator tree is a point in the tree that represents an event (involving an operator)
in a plan. Each node might have subordinate nodes—that is, each event might generate a
subordinate event or events in the plan.
DescriptionData TypeColumn Name
Reserved for future use.CHAR(60)MODULE_NAME
Statement name; truncated on the right if longer than 60
characters.
CHAR(60)STATEMENT_ NAME
Unique system-generated plan ID automatically assigned
by Neoview SQL; generated at compile time.
LARGEINTPLAN_ID
Sequence number of the current operator in the operator
tree; indicates the sequence in which the operator tree
is generated.
INTSEQ_NUM
Current operator type. For a full list of valid operators,
see the Neoview Query Guide.
CHAR(30)OPERATOR
Sequence number for the first child operator of the
current operator; null if node has no child operators.
INTLEFT_CHILD_ SEQ_NUM
Sequence number for the second child operator of the
current operator; null if node does not have a second
child.
INTRIGHT_CHILD_ SEQ_NUM
For operators in scan group, full name of base table,
truncated on the right if too long for column. If
correlation name differs from table name, simple
correlation name first and then table name in
parentheses.
CHAR(60)TNAME
Estimated number of rows that will be returned by the
current operator. Cardinality appears as
ROWS/REQUEST in some forms of EXPLAIN output.
For the right child of a nested join, multiply the
cardinality by the number of requests to get the total
number of rows produced by this operator.
REALCARDINALITY
Estimated cost associated with the current operator to
execute the operator.
REALOPERATOR_COST
Estimated cost associated with the current operator to
execute the operator, including the cost of all subtrees
in the operator tree.
REALTOTAL_COST
Cost vector of five items, described in the next table.VARCHAR (200)DETAIL_COST
Additional information about the operator. For a detailed
look at all operators, see the Neoview Query Guide.
VARCHAR (3000)DESCRIPTION
The DETAIL_COST column of the EXPLAIN function results contains these cost factors:
An estimate of the number of seconds of processor time it might take to execute the
instructions for this operator. A value of 1.0 is 1 second.
CPU_TIME
An estimate of the number of seconds of I/O time (seeks plus data transfer) to
perform the I/O for this operator.
IO_TIME
An estimate of the number of seconds it takes for the messaging for this operator.
The estimate includes the time for the number of local and remote messages and
the amount of data sent.
MSG_TIME
EXPLAIN Function 351