SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—640322-001
2-147
Considerations for EXPLAIN
Machine-readable [OPTIONS 'm'] Considerations
The machine-readable option provides an output in the format that can be read only by
machines but is suitable for programs.Table 2-4 lists the fields of the OPTIONS 'm'
output.
Table 2-4. Fields of OPTIONS 'm' Output
Column name Data Type Description
MODULE NAME CHAR (60) Reserved for future use.
STATEMENT NAME CHAR (60) Statement name; truncated on the right if
longer than 60 characters.
PLAN_ID INT Unique system-generated plan ID
automatically assigned by SQL; generated at
compile time.
SEQ_NUM CHAR (30) Sequence number of the current operator in
the operator tree; indicates the sequence in
which the operator tree is generated.
OPERATOR CHAR (30) Current operator type.
LEFT_CHILD_SEQ_NUM INT Sequence number for the first child operator of
the current operator; displays NULL if the
operator has no child operators.
RIGHT_CHILD_SEQ_NUM INT Sequence number for the second child
operator of the current operator; displays
NULL if the operator does not have a second
child.
TNAME CHAR (60) For operators in a scan group, the full name of
base table is truncated on the right if it is too
long for the column. If the correlation name
differs from the table name put the correlation
name first and then table name in
parentheses.
CARDINALITY REAL Estimated number of rows that are returned by
the current operator.
OPERATOR_COST REAL Estimated cost associated with the current
operator to execute the operator.
TOTAL_COST REAL Estimated cost associated with the current
operator to execute the operator, including the
cost of all subtrees in the operator tree.
DETAIL_COST VARCHAR
(200)
Cost vector of five items, which are described
in detail in Table 2-5, Cost Factors of
DETAIL_COST column.
DESCRIPTION VARCHAR
(3000)
Additional information about the operator. For
more information about the DESCRIPTION of
all operators, see the SQL/MX Query Guide.