SQL Optimizer for DB2 LUW 4.4 - Installation Guide

Right Pane for SQL Analyzed Folder

In the Index Impact Analyzer window, when the SQL Analyzed folder is selected in the left pane, the following information is displayed in the right pane.

Cost Summary button

Displays all the SQL statements and shows the DB2 LUW cost for the SQL statement in each Scenario so that you can compare the cost of each SQL statement to see if the cost increases or decreases with the index set. For each SQL statement, it displays the highest DB2 LUW cost in red and the lowest cost in green.

SQL Classification button

Displays all the SQL statements and shows the SQL Classification (Simple, Complex, and Problematic). The Baseline column shows the SQL Classification without the proposed indexes. The other columns show the SQL Classification with each proposed index set.