Command Center -- Access Plan

Use the Access Plan page of the Command Center notebook 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 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

Operands

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

Information on this view

• Reading the contents of the Access Plan page