Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.3.1 - Installation Guide

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

  1. Right-click the Access Plan pane and select View Plan.

  2. 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"


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating