Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.3.1 - Release Notes

Create an Index Usage Analysis

To create an Index Usage Analysis

  1. Click image\B_IndexUsageAnalyzer.gif.

  2. If no analysis exists in the Index Usage Analyzer, then the New Analysis wizard appears automatically. Otherwise, you can open the New Analysis wizard in the following ways:

  3. Click image\B_NewAnalysis_UIA.gif.

  1. Use the following pages in the New Analysis wizard to select the options for creating an analysis.

Analyzer

Selected SQL

When the analysis is finished, the Index Usage Analysis Details window appears with information about the retrieval of the access plan for each SQL statement.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating