Review Execution Plans

SQL Optimizer for IBM DB2 z/OS

Review Execution Plans

The execution plan can be displayed in different ways to help you get more detailed information.

To change how the execution plan is displayed

  1. Right-click the plan 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

Tips: 

  • You can change the colors used to highlight different items for the current plan only by right-clicking the plan and selecting Plan Options. You can change colors for all execution plans in Options | General | Execution Plan. Execution Plan Options

  • You can use the toolbar to the right of the Execution Plan pane to change the details displayed.

 

Related Topics

About Execution Plans

Animate Execution Plans

Copy Execution Plans