SQL Optimizer for SAP ASE 3.9 - Release Notes

Create an Index Usage Analysis

To create an Index Usage Analysis

1. Click to open the Index Usage Analyzer window.

2. If no analysis exists in the Index Usage Analyzer then the New Analysis wizard displays automatically. Otherwise, click .

3. The New Analysis wizard has two pages to select the options for creating an analysis.

• Analyzer
• Selected SQL

4. Make the selections from these two tab page. Click OK.

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

Related Topics

Index Usage Analyzer Overview

Index Usage Analyzer Window