Quest SQL Optimizer for IBM® DB2® LUW maximizes 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.
The SQL Inspector identifies SQL statements with performance problems by extracting SQL statements and SQL performance statistics from the database. With the Add Inspector window, you can create an Inspector, select which approach to use, and specify your retrieval criteria and timeframe for capturing the SQL statements.
The SQL Inspector data directory is where the data files are created while executing the Inspect function. The data directory path is set in the Options window.
Select the Directory Setup tab.
The default setting for this directory is:
C:\Users\User\Application Data\Quest Software\Quest SQL Optimizer for DB2 LUW\DATA
Changes to this directory cannot be made while the SQL Inspector is active.
Note: It is advisable not to change the data directory after you have used this function, as files created during inspecting are kept in this directory.
To open the SQL Inspector window