Review Access Plans
The access plan can be displayed in different ways to help you get a clear picture of the steps or detailed information about the steps that DB2 LUW is taking to execute a SQL statement.
For each location where the access plan is displayed, it will remember the display view option (As Tree Plan, As Plain Language Plan, As Graphic Plan, or As MS Graphic Plan) that you have selected from the right-click View Plan option. It will use that option the next time you view the access plan in the same location in the program.
To change how the access plan is displayed
-
Right-click the Access Plan pane and select View Plan.
-
Select one of the following display options:
As Tree Plan
As Plain Language Plan
As Graphic Plan
As MS Graphic Plan
Figure: Access Plan "As Tree Plan"
Figure: Access Plan "As Plain Language Plan"
Figure: Access Plan "As Graphic Plan"
Figure: Access Plan "As MS Graphic Plan"