SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
8-71
Considerations for EXPLAIN
Operators are grouped together for purposes of display within the EXPLAIN statement.
For more information about the use of the result table of the EXPLAIN function, see the
SQL/MX Query Guide.
SORT_PARTIAL_AG..._LEAF
SORT_PARTIAL_AG..._ROOT
SORT_PARTIAL_GR..._LEAF
SORT_PARTIAL_GR..._ROOT
SORT_SCALAR_AGGR
SPLIT_TOP
SUBSET_DELETE
SUBSET_UPDATE
TRANSPOSE
TUPLE_FLOW
TUPLELIST
UNIQUE_DELETE
UNIQUE_UPDATE
UNPACK
VALUES
Groupby
Groupby
Groupby
Groupby
Groupby
Exchange
DAM subset
DAM subset
Data mining
Join
Tuple
DAM unique
DAM unique
Rowset
Tuple
LEFT_CHILD_
SEQ_NUM
INT Sequence number for the first child operator of the current
node (or operator); null if node has no child operators.
RIGHT_CHILD_
SEQ_NUM
INT Sequence number for the second child operator of the
current node (or operator); null if node does not have a
second child.
TNAME CHAR(60) 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.
CARDINALITY REAL Estimated number of rows that will be returned by the
current node.
OPERATOR_
COST
REAL Estimated cost associated with the current node to execute
the operator.
TOTAL_COST REAL Estimated cost associated with the current node to execute
the operator, including the cost of all subtrees in the
operator tree.
DETAIL_COST VARCHAR
(200)
Tokenized cost vector.
DESCRIPTION VARCHAR
(3000)
Additional information about the operation in the form of a
stream of token pairs.
Column Name Data Type Description