SQL Optimizer for DB2 LUW 4.4 - Installation Guide

Add SQL to SQL Repository

SQL statements are stored in the SQL Repository for use in an Index Impact Analysis, and an Index Usage Analysis.

To add SQL statements

1. Click .

2. If no SQL exists in the SQL Repository Add SQL wizard appears automatically. Otherwise, click .

3. Select SQL | Add SQL or Add SQL from SQL Scanner.

4. Use the following pages in the Add SQL wizard has pages to select the options for saving the SQL statement to the SQL Repository.

   General

   SQL Information

The SQL syntax is checked and the access plan retrieved before adding a new node to the SQL tree view with the SQL name. Each SQL statement added to the SQL Repository contains an access plan, SQL classification type (Simple, Complex or Problematic) and the current connection information (login name, database alias, and schema). The access plan stored with the SQL statement is important as it indicates the current performance of the SQL.

SQL statements can also be added to the SQL Repository from other modules.