Review Alternatives

SQL Optimizer for IBM DB2 z/OS

Review Alternatives

Use the Alternatives pane to review the SQL text and execution plan for the alternatives SQL Optimizer generates. You can also review the run-time statistics for your original SQL statement and the alternatives after you execute the statements.

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

To review details for an alternative

  1. Select the SQL Details tab in the main window.
  2. Select an alternative in the Alternatives pane.

  3. Review details for the alternative in the Alternative Details and Execution Plan panes.

  

Related Topics  

Optimize SQL Statements

Automatically Optimize SQL Statements

Alternative SQL Text