Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.1 - Installation Guide

Create User Defined Alternatives

In addition to using SQL Optimizer to generate alternative statements, you can create user defined alternatives. You can create user defined alternatives using SQL text from your original SQL statement or from SQL text of an alternative SQL Optimizer generated.

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

To create a user defined alterative

  1. Select the SQL Details tab in the main window.
  2. Enter the SQL statement in the in the Alternative Details pane.

  3. Click .

  4. Edit the statement in the SQL Text pane to create a user defined alternative.

    Note: To create a user defined alternative using SQL text of an alternative SQL Optimizer generated, right-click an alternative and select User Alternative.

Caution: SQL Optimizer does not check that user defined alternatives are semantically equivalent to your original SQL statement. Review the execution statistics for user defined alternatives to compare the results with your original statement. See View Execution Statistics for more information.

 

Related Topics

Compare SQL Statements

Test Run SQL Alternatives

Related Documents