Neoview Query Guide (R2.2)

• Node Name describes the operator type; in this case, INDEX_SCAN.
• Node Seq. Num. is 1, which indicates that the operator is first in the sequence.
• Left Child Seq. Num. is 0, which indicates that this operator has no left child.
• Right Child Seq. Num. is 0, which indicates that this operator has no right child. If both the
left and right child sequence numbers are 0, then this is a leaf operator.
• 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 operator to execute
the INDEX_SCAN.
• Total Cost provides the estimated cost associated with the current operator to execute the
INDEX_SCAN, including the cost of all subtrees in the operator tree.
Reviewing the Cost Details
The items listed in the Cost Details tab are the same as those items described in the DETAIL_COST
column of the EXPLAIN function results. For a detailed description of each of these items, see
the summary of the Cost Details in the EXPLAIN function in the Neoview SQL Reference Manual.
Additional Table Information
The Description tab provides additional table information, including key columns, scan type,
scan direction, and so on.
26 Using Visual Query Planner