Displaying and using an access plan graph

Use the Access Plan Graph window to display and use an access plan graph, which is a graphical representation of an access plan. From it, you can view the details for:

• Tables (and their associated columns) and indexes
• Operators (such as table scans, sorts, and joins)
• Table spaces and functions.

Fields and controls

Tasks

• Displaying an access plan graph
• Magnifying and viewing different parts of a graph
• Reading the symbols in an access plan graph
• Getting more details about the objects in a graph
• Changing the appearance of a graph

Related information

• Creating an access plan graph
• Viewing explainable statements for a package
• Viewing the history of previously explained SQL statements
• Viewing a graphical representation of an access plan
• Using Visual Explain windows and notebook