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

Right Pane for SQL Statements

When a SQL statement is selected in the left pane, the following information is displayed in the right pane.

Properties button

Displays general information about the analysis, information on the connection used to retrieve the access plans and the database settings at the time of the analysis.

SQL Information button

Displays the access plan and the SQL Information pane.

Index Used button

Lists the table name, indexes and the key for all indexes used in the SQL statement.

To save a list of all the used indexes

  1. Right-click and select Save.

  2. In the Save Format window, select Text, HTML, or Excel Convertible (Spreadsheet).


Create an Index Usage Analysis

To create an Index Usage Analysis

  1. Click image\B_IndexUsageAnalyzer.gif.

  2. If no analysis exists in the Index Usage Analyzer, then the New Analysis wizard appears automatically. Otherwise, you can open the New Analysis wizard in the following ways:

  3. Click image\B_NewAnalysis_UIA.gif.

  1. Use the following pages in the New Analysis wizard to select the options for creating an analysis.


Selected SQL

When the analysis is finished, the Index Usage Analysis Details window appears with information about the retrieval of the access plan for each SQL statement.


Update an Index Usage Analysis

You can update an analysis for unused indexes by rerunning the analysis with the same SQL statements from the original analysis or you can add or delete SQL statements from the analysis.

To update an analysis

  1. Right-click the analysis name in the left pane of the Index Usage Analysis window and select Update Analysis.

  2. The Update Analysis wizard has two pages to select the options for changing an analysis before it is updated. It is not necessary to make any changes on these pages before rerunning the analysis.

On the Analyzer page, you can change the name and description of the analysis.

On the Selected SQL page, you can add or delete SQL statements to the analysis.

When the analysis is finished, the Index Usage Analysis Details window appears with information the retrieve of the access plan for each SQL statement.


New Analysis Wizard: Analyzer Page

The Analyzer tab is used to name the analysis and to select the folder where the Analyzer information will be stored.




Enter the name for the analysis.


Enter the description for the analysis.

Last modified

Displays the last modified date and time.

Save location

Displays the folder in the tree where the analysis is saved.

In the Select save location pane, select the folder where you want to save the analysis. To create a new folder, click image\B_AddFolder.gif.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating