Get Execution Plans

SQL Optimizer for IBM DB2 z/OS

Get Execution Plans

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

SQL Optimizer automatically retrieves the execution plan when you optimize or test run a SQL statement.

To get the execution plan

  1. Select the Optimize SQL tab.

  2. Enter a SQL statement in the Alternative Details pane.

  3. Click .

 

Related Topics

About Execution Plans

Animate Execution Plans

Copy Execution Plans