Chat now with support
Chat mit 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

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® 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

 

Add Inspector

To add an Inspector

Click .

 

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen