SQL Optimizer for DB2 LUW 4.4 - Installation Guide

Index Generation Details

The Index Generation Details dialog is optional and can be displayed after index generation. This dialog displays the following:

• Number of virtual indexes investigated

• Number of virtual index-sets initially created

• Number of virtual index sets that produced unique access plans

• Number of virtual index sets eliminated due to identical access plan

• A warning message if the Index Generation Quota or Index Set Generation Quota is reached.

  Note: Consider increasing the quota values on the Quota page for SQL Rewrite in Options to increase the likelihood of finding index sets that can give you better performance for the original SQL statement.

Unless disabled, the Index Generation Details dialog displays each time an index-generation process completes. To disable this window, clear the Show details on next index generation option in the Index Generation Details dialog.

If no index-set alternatives are available, the Optimize button is enabled to let you start an automatic rewriting of the original SQL statement for optimization.

To open the Index Generation Details dialog anytime

Select View | Show Index Generation Details.