Reading the contents of the Access Plan Graph window

Top area of the window

The top area of the Access Plan Graph window identifies the statement whose access plan is displayed on the graph.

This part of the window also shows:

• The statement's explain date and time
• Its total estimated cost
• The type of parallelism of the system in which this statement is explained. It can be one of the following types:
  • None
  • Intra-partition parallelism
  • Inter-partition parallelism
  • Full parallelism (intra-partition and inter-partition)

The Graph

The nodes in the graph represent operands (tables, indexes, or table functions), and the operators that act on them. To view detailed statistical information for a node, double-click on it.

To view the information shown in the graph in more detail, drag the zoom slider at the left-hand side of the window to the right.

Float values may be presented in scientific notation.

For help on how to use this window, see Creating an access plan graph.