SQL Optimizer for SAP ASE 3.8 - Installation Guide

Tchater maintenant avec le support

Obtenir une aide instantanée
Terminer l’enregistrement

Se connecter

Demander les tarifs

Contacter le service des ventes

Install SQL Optimizer Register SQL Optimizer Installation Requirements Silent Install of SQL Optimizer Uninstall SQL Optimizer

Configuration

Configure SQL Optimizer

Create an Index Impact Analyzer

To create an Index Impact Analyzer

Click $image\B_IndexImpactAnalyzer.gif$ to open the Index Impact Analyzer window.
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.

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

Analyzer
Selected SQL
Index
Abstract Plan

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.

Veuillez sélectionner votre produit

Afin de mieux répondre à vos besoins, précisez l'objet du tchat:

Solutions recommandées pour votre problème

SQL Optimizer for SAP ASE 3.8 - Installation Guide

Create an Index Impact Analyzer