Best Alternative Criteria Options

SQL Optimizer for IBM DB2 z/OS

Best Alternative Criteria Options

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

To set the best alternative options

  1. Click .
  2. Select Optimize SQL | Test Run | Best Alternative Criteria

  3. Review the following for additional information:

    Best SQL Alternative Selection Criteria Description
    Best alternative selected based on lowest

    Select one of the following :

    • Total Elapsed Time—Select elapsed run time as the criteria to find the best SQL alternative t.
    • First Row Time—Uses the time to retrieve the first record to find the best SQL alternative.

    Default: Elapsed Time

   

Related Topics

Test Run Settings Options

Execution Method Options

Order and Termination Options