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

General

Execution Plan 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 plan options

  1. Click .
  2. Select General | Execution Plan.

  3. Review the following for additional information:

    Execution Plan Description

    TABLE ACCESS FULL warning threshold

    Specify a table size threshold at which the TABLE ACCESS FULL operation is highlighted in red.

    Color

    Specify the color of the individual items in the query plan by clicking the Color column in the row for the item and selecting the new color from the dialog.

    Font

    Specify the font settings of the individual items in the query plan by clicking the Font column in the row for the item and selecting the new settings from the dialog.

    Note: The execution plan displays in several panes. The color and font settings in this window controls the settings in all the Execution Plan panes. Right-click the execution plan and select Plan Options to customize display options for individual panes.

Note: These options apply to SQL Optimizer..

 

Related Topic

Directory Setup Options

General Options

Directory Setup Options

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

To set directory setup options

  1. Click .
  2. Select General | Directory Setup.
  3. Review the following for additional information:

    Directory for

    Description

    Default Directory
    Optimize SQL data directory Optimize SQL files C:\Documents and Settings\User\Application Data\Quest Software\Quest SQL Optimizer for DB2 z/OS\version\Optimize SQL Data

 

 Related Topics

General Options

Appearance Options

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

To restore layouts

  1. Click .
  2. Select General | Appearance.

  3. Review the following for additional information:

    General Options Description

    Restore Layouts

    Click and Yes.

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

To set appearance options

  1. Click .
  2. Select General | Appearance.

  3. Review the following for additional information:

    Font Settings Description

    SQL Text Editor

    Select the font settings for the SQL Text Editor.

    Other Data

    Select the font settings for other data.

    Size

    Select the font size.

 

 Related Topics

Directory Setup Options

Related Documents