Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4 - Installation Guide

View Index Impact Analysis Details

ClosedView the Index Impact Analysis Details Window

The Index Impact Analysis Details window displays information about the creation of the indexes and the retrieval of the access plans. The Index Impact Analysis Details window appears after the Index Impact Analysis process is completed unless the Show details on next generation checkbox in the Index Impact Analysis Details window is unchecked.

To view the Index Impact Analysis Details window

After an Index Impact Analysis is complete, select View | Last Index Impact Analysis Details when the Index Impact Analyzer window is active. 

Review this information to see if an error occurred during the retrieval of the access plan. Errors may occur if the selected SQL statements are from one schema and you have set another schema in the Schema list at the bottom left of the main window.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating