Viewing a graphical representation of an access plan

Use the Access Plan Graph window to view a graphical representation of the access plan of an explained SQL statement. The nodes in the graph represent tables and indexes and each operation on them. The links between the nodes represent the flow of data.

Tasks

• Changing graph settings
• Dynamically explaining an SQL statement
• Printing an access plan graph
• Viewing optimization parameters
• Viewing text (or optimized text) for an SQL statement

Table spaces

• Viewing table spaces
• Viewing table space statistics

Functions

• Viewing functions
• Viewing function statistics

Operators

• Viewing operator details
• Viewing partitioned databases

Operands

• Viewing column distribution statistics
• Viewing indexes
• Viewing index statistics
• Viewing page fetch pairs statistics
• Viewing referenced columns
• Viewing referenced column statistics
• Viewing table function statistics
• Viewing table statistics

Information on this view

• Reading the contents of the Access Plan Graph window

Related information

• Creating an access plan graph
• Using Visual Explain windows and notebook