Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.3.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
About SQL Optimizer for IBM DB2 LUW Getting Started Options SQL Scanner SQL Optimizer SQL Formatter SQL Inspector Database Explorer SQL Repository Index Impact Analyzer Index Usage Analyzer User-Defined Temp Table Editor Functions SQL Functions SQL Information and Functions Activity Log
Tutorials About us Copyright


ClosedView General tab – General button options

The General page of the General tab on the Options window allows users to specify the general settings.

Character set

Character set


Character set

(Default = English (DOS) )

Specify the language set used to enter and display SQL and data. This setting does not affect the language of the program interface. It is always in English.

Display process description animation during optimization

Process Description


Show process description

(Default = checked)

Specify whether to show an animation describing the optimization process. This option is useful for first time users. It also indicates that the optimization process is still working when the process bar stays at the same percent for a long period of time.

Maximize window

Maximize Window


Maximize the first window opened

(Default = unchecked)

Specify that the first window you open is maximized. Every window that you open after that also opens maximized.

If you "restore down" a window, then all open windows are "restored down" and any other window that is open is not maximized as it is opened. Once all windows are closed, the next window that is open is maximized as it is opened.

Note: This feature only applies to windows with the Minimize, Maximize, and Close boxes in the upper right corner of the window.

Load Data Dictionary

Load Data Dictionary


Load data dictionary after database connection

(Default = unchecked)

Specify that the database dictionary is automatically loaded into the memory of the computer every time you connect to a database.

When this option is not selected, the specific information needed from the database is loaded when the SQL statement is parsed for functions such as scanning, optimization, and index generation. This save time when you are initially connecting to the database from each module, but it adds a slight bit of time later when the SQL statement is parsed.

Use plan table from SYSTOOLS Select this option if you want SQL Optimizer to use the EXPLAIN tables created under SYSTOOLS. If EXPLAIN tables already exist under the current schema, SQL Optimizer asks you to specify which set of tables to use.

Run time

Run Time


Row array size for getting elapsed time

(Default = 100, Range 0 to 99990)

Define the number of rows used to fetch rows returned by the SQL statement while retrieving the run time for all records.

SQL Parameters

SQL Parameters


Enable SQL parameter history

(Default = checked)

Specify to save the parameter information that you enter into the Parameters window so that next time that you are prompted to enter the values for the parameters, the data type and value that you last used for a parameter name are automatically entered for you. The parameter names are case sensitive, so dpt_id and DPT_ID are treated as two different parameters. The directory where this information is save is set in the Directory Setup options.

Maximum number of parameters

(Default = 100, Range 10 – 9999)

Specify the maximum number of parameters that will be saved. When the maximum number is reached, the parameter name that is the longest unused will be removed from the file when a new parameter name is added.


Related Topics


ClosedView General tab – Message button options

The Message page of the General tab on the Options window allows users you to decide which confirmation messages to show.

Display confirmation message

Confirmation Message


Show confirmation before closing Application


Specify whether to show a confirmation message when closing SQL Optimizer.

Show confirmation before closing optimized SQL statements


Specify whether to show a confirmation message when closing the SQL Optimizer window.

Show confirmation before saving data


Specify whether to show a confirmation message when saving data. For example, from the Database Explorer (Data tab) windows.

Show confirmation before closing Index Expert


Specify whether to show a confirmation message when closing the Index Expert window.


Result Set

ClosedView General tab – Result Set button options

The Result Set page of the General tab on the Options window allows you to set option for editing data.

Edit data

Edit data


Auto Commit when finished editing

Automatically commit the changes after each record is changed when editing the data in the Database Explorer window.



Generate Indexes Settings

Quest SQL Optimizer for IBM® DB2® LUWmaximizes SQL performance by automating the manual, time-intensive and uncertain process of ensuring that SQL statements are performing as fast as possible. SQL Optimizer analyzes, rewrites, and evaluates SQL statements within multiple database objects, files, or SQL statements captured by the DB2 Event Monitor. With SQL Optimizer, you can analyze and optimize all your problem SQL from multiple sources. SQL Optimizer also provides you a complete index optimization and plan change analysis solution, from index recommendations to simulated index impact analysis, through comparison of multiple SQL access plans.

SQL Optimizer provides you with the following main modules.

SQL Optimizer (including SQL Rewrite and Generate Indexes functions)

SQL Formatter

Database Explorer

SQL Scanner

SQL Inspector

SQL Repository

Index Impact Analyzer

Index Usage Analyzer


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating