SQL Optimizer for DB2 LUW 4.4 - Installation Guide

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