Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4 - Installation Guide

About Options

To change an Options setting

Click image\B_Options.gif to specify the desired settings.

When you change the settings, your latest settings are always saved and restored each time to exit and restart the program. You can also save several sets of option settings either by saving settings from one or more tabs or by saving all the option settings.

To save specific settings so that you can use them later

  1. In the Options window, click Save.

  2. Enter a filename for the saved settings. Click Save.

  3. From the Save Options Profile window, select the tabs for the settings you want to save. Click OK.

To restore the saved settings

  1. In the Options window, click Load.

  2. In the Open File window, select the filename. Click Open.

  3. From the Save Options Profile window, select the tabs for the settings you want to load.

     

The Options window is divided into the following tabs and pages:

Optimization

Optimization Intelligence

Optimization (1)

Optimization (2)

SQL Options

Quota

General

Editor

Activity Log

Plan

SQL Scanner

Options

General

SQL Classification

Directory Setup

Linkage

General

General

Message

Result Set

Index Expert

Intelligence

Index Options

General

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating