SQL Optimizer for DB2 LUW 4.4

Item	Description
Inspector Name	User-defined unique Inspector name.
Status	Current status on the Inspector. This column will remain blank until inspecting starts.
No. of SQL	Total number of SQL statements retrieved from the monitoring tables.
Start At	Date and time of when the inspecting process starts.
End At	Date and time of when the inspecting process ends.
Last Modified	Date and time of when the Inspector was last modified.
Description	Description of the Inspector defined by the user.

Statistics pane

Displays statistics for each SQL statement retrieved from the database:

SQL Text pane

Displays the SQL text for the statistic that is selected in the Statistics pane.

Status Bar Information

The status bar consists of the following information:

Item	Description
Data Directory	Directory path shows where the data files produced during inspecting are saved. You can define the path of your data directory in the Preferences window. While inspecting, a progress bar will be shown to indicate the inspecting progress.
Total Inspectors	Total number of Inspectors.
Completed	Total number of Inspectors already executed.
Remaining	Total number of Inspectors that have not been executed.

Statistics: Executed SQL

Each executed SQL statement has the following performance statistics:

Statistics	Description
Executions	Number of times the statement has been executed.
Logical Reads	Number of data pages read from the buffer pool (logical).
Physical Reads	Number of data pages read from the buffer pool (physical).
CPU Time	CPU time used by the statement.
Compilations	Number of different compilations for a specific statement.
Worst Preparation Time	The longest number of milliseconds required to prepare a specific statement.
Best Preparation Time	The shortest number of milliseconds required to prepare a specific statement.
Rows Deleted	Number of attempted row deletions.
Rows Inserted	Number of attempted row insertions.
Rows Updated	Number of attempted row updates.
Rows Read	Number of rows read to return result set.
Rows Written	Number of rows in the table changed (inserted, deleted or updated).
Stmt Sorts	Number of times a set of data was sorted.
Sort Overflows	Number of sorts that may have required temporary disk space for storage after running out of sort heap.
Sort Time	Total number of milliseconds for all executed sorts.
Total Execute Time	Total time spent to execute a particular statement in the SQL cache.
Stmt Text	Text of the statement
Partition	Database partition from which data was retrieved for the row.
Snapshot Time	Date and time of the snaphot.

Statistics: Executing SQL

Each executing SQL statement has the following performance statistics:

Statistics	Description
Executions	Number of times the statement has been executed.
Logical Reads	Number of data pages read from the buffer pool (logical).
Physical Reads	Number of data pages read from the buffer pool (physical).
CPU Time	CPU time used by the statement.
Compilations	Number of different compilations for a specific statement.
Worst Preparation Time	The longest number of milliseconds required to prepare a specific statement.
Best Preparation Time	The shortest number of milliseconds required to prepare a specific statement.
Rows Deleted	Number of attempted row deletions.
Rows Inserted	Number of attempted row insertions.
Rows Updated	Number of attempted row updates.
Rows Read	Number of rows read to return result set.
Rows Written	Number of rows in the table changed (inserted, deleted or updated).
Stmt Sorts	Number of times a set of data was sorted.
Sort Overflows	Number of sorts that may have required temporary disk space for storage after running out of sort heap.
Sort Time	Total number of milliseconds spend performing sorts when executing a section.
Total Execute Time	Total time spent to execute a particular statement in the SQL cache.
Stmt Text	Text of the statement
Partition	Database partition from which data was retrieved for the row.
Snapshot Time	Date and time of the snaphot.

Add 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)

Index Impact Analyzer

Index Usage Analyzer