Access Plan Graph

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 a large access plan graph
• Viewing optimization parameters
• Viewing optimized text for an SQL statement
• Viewing 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 database partitions

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

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]