Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.2 - User Guide

SQL Optimizer for IBM® DB2® LUW
UsageStatistics 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

SQL Inspector

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.

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


SQL Inspector Overview

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.


Related Topics


SQL Inspector Functions

Data Directory Setting

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.

  1. Click .

  2. 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.


Related Topic

Open SQL Inspector

To open the SQL Inspector window

Click .


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating