Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Third-party contributions Copyright

Intelligence Options (Index Generation)

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

To set intelligence options

  1. Click .

  2. Select Optimize SQL | Index Generation | Intelligence.
  3. Select whether to use custom or predefined intelligence levels. If you select predefined, the levels range as follows:

 

Related Topics

Index Setting Options

Test Run

Test Run Options

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

To set test run settings options

  1. Click .
  2. Select Optimize SQL | Test Run | Test Run Settings

  3. Review the following for additional information:

    Test Run Settings

    Description

    Custom

    Enables you to customize the settings.

    Predefined

    Uses the predefined set of options.

 

Related Topics

Execution Method Options

Order and Termination Options

Execution Method Options

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

To set execution method options

  1. Click .
  2. Select Optimize SQL | Test Run | Execution Method

  3. Review the following for additional information:

    Execution Method Description

    Maximum rows to be retrieved (records)

    Select this checkbox and then enter the maximum number of rows to retrieve for a test run of all records.
    Run Time Retrieval Method Description

    Run SQL options

    Select one of the following options:

    • Run all SQL twice if original SQL runs faster than (seconds)—Combines the Original SQL twice and all others once and the All SQL twice options into one option and allows you to determine (by the number of seconds a SQL statement runs) which option to use. The original SQL statement always runs twice. The SQL alternatives run twice if the original SQL statement runs in less time than the value specified. Otherwise, the SQL alternatives all run once.
    • Original SQL twice and all others once—Caches data from a table into memory the first time you access it. The next time you access that data, it is already in memory so the following SQL statements run faster. To provide an accurate comparison, the first SQL statement runs twice but only the time from the second run is compared to the times for the other statements.
    • All SQL twice—Executes all SQL statements twice to eliminate factors that can affect the accuracy of the results. If you recently executed a SQL statement, the information for that statement may be cached and the statement may execute faster. This option eliminates time variation caused by caching since it runs all SQL statements twice but only uses the second run time for comparison.
    • All SQL once—Executes all SQL statements once. For long running SQL, you do not need to run any statement twice since the effect from caching diminishes over time.

   

Related Topics

Order and Termination Options

Related Documents