SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Reviewing Query Execution Plans
HP NonStop SQL/MX Query Guide—523728-003
4-18
Graphically Displaying Execution Plans
•
Node Seq. Num. is 1, which indicates that the node was first in sequence during
optimization.
•
Left Child Seq. Num. is 0, which indicates that this is not a join.
•
Right Child Seq. Num. is 0, which indicates that this is not a join. If both the left
and right child sequence numbers contain values, the node is a join.
•
Table Name provides the catalog.schema.tablename of the table scanned.
•
Cardinality provides the estimated rows returned by the INDEX_SCAN.
•
Operator Cost provides the estimated cost associated with the current node to
execute the INDEX_SCAN.
•
Total Cost provides the estimated cost associated with the current node to
execute the INDEX_SCAN, including the cost of all subtrees in the operator tree.