Options
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)
About Options
To change an Options setting
Click 
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
-
In the Options window, click Save.
-
Enter a filename for the saved settings. Click Save.
-
From the Save Options Profile window, select the tabs for the settings you want to save. Click OK.
To restore the saved settings
-
In the Options window, click Load.
-
In the Open File window, select the filename. Click Open.
-
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:
SQL Rewrite 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 Rewrite Settings
The SQL Rewrite tab on the Options window consists of several pages that are selected from buttons on the left. These settings allow you to select the optimization level and other options that the SQL Rewrite function uses to create alternatives for your SQL.
The settings include the following: