Neoview SQL Reference Manual (R2.5)

key_columns ............ R_KEY
begin_key .............. (R_KEY = <min>
end_key ................ (R_KEY = <max>
---SQL operation complete.
Machine-Readable [OPTIONS 'm'] Considerations
The machine-readable format also displays all of the plan data, but in a format easy to process
by programs, one line per operator. This option provides the same output as the EXPLAIN
function, but uses a different command to obtain the output. Each line is about 4000 characters
long. This format makes the output of this mode difficult for humans to read (which is why it is
called machine readable.) The advantage of this format is that the results can be easily stored,
retrieved, and manipulated by SQL statements. For additional information about the EXPLAIN
function, see the “EXPLAIN Function” (page 401). For information about a use for this format,
see the Neoview Query Guide.
The fields of the OPTIONS ‘m’ output are slightly different than the fields shown in OPTIONS
'n' and 'e' output:
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 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 operator
types, see the Neoview Query Guide.
CHAR(30)OPERATOR
Sequence number for the first child operator of the
current operator; null if operator has no child operators.
INTLEFT_CHILD_ SEQ_NUM
Sequence number for the second child operator of the
current operator; null if operator 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 are 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
130 SQL Statements