Tchater maintenant avec le support
Tchattez avec un ingénieur du support

SQL Optimizer for SAP ASE 3.8 - Installation Guide

Create an Index Impact Analyzer

To create an Index Impact Analyzer

  1. Click image\B_IndexImpactAnalyzer.gif to open the Index Impact Analyzer window.

  2. If no analysis exists in the Index Impact Analyzer then the New Analysis wizard displays automatically. Otherwise, click image\B_NewAnalysis_IIA.gif to open the New Analysis wizard.

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

  1. Name the Analyzer, select the SQL statements for analysis, and specify the DDL for the proposed indexes in the New Analysis window.

Note: The indexes are physically created and then dropped after the query plans are obtained. This may affect other SQL statements executing on the database during this period.

 

Related Topics

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation