SQL Optimizer for SAP ASE 3.9

The Index Impact Analyzer window displays the information about the SQL statements that are saved in the Index Impact Analyzer. The display in the right section of the window depends on what is selected in the left pane.

Left pane - Analyzer List

Always displays a tree diagram of the Analyzers and the folders they are stored in.

Right Pane

The right pane displays a variety of different information depending upon what is selected from the tree diagram in the left pane.

You can display information for the following:

Right Pane for Analyzers

Index Impact Analyzer > Index Impact Analyzer Window > Right Pane for Analyzers

In the Index Impact Analyzer window, when an Analyzer is selected in the left pane, the following information displays in the right pane.

Properties Button

Displays general information about the analysis, information on the connection used to retrieve the query plans and the SQL statements used in the analysis.

Right Pane for Scenarios Analyzed Folder

Index Impact Analyzer > Index Impact Analyzer Window > Right Pane for Scenarios Analyzed Folder

In the Index Impact Analyzer window, when the Scenarios Analyzed Folder is selected in the left pane, the following information displays in the right pane.

Summary button

Provides a summary of the Estimated I/O Cost and SQL classification for the SQL statements before and after the proposed indexes were created.

Chart button

Charts the total Estimated I/O Cost of the SQL statements with and without the proposed indexes.

Right Pane for Scenario

Index Impact Analyzer > Index Impact Analyzer Window > Right Pane for Scenario

In the Index Impact Analyzer window, when the Scenario folder is selected in the left pane, the following information displays in the right pane.

Properties button

Displays general information about the analysis and the index name.

Prognosis button

Displays 3 panes in the right section of the window.

Charts and Summary tabs [Top right pane]

The Chart tab displays five charts of the comparison information for the query plans from before the analysis and during the analysis.

The Summary tab displays summarized statistics for the Scenario,

SQL Classification and Plan Change Comparisons [Middle right pane]

A grid displays the information about each query plan from before the analysis and during the analysis in a comparison format.

SQL Text and SQL Information tabs [Bottom right pane]

The SQL statement that is highlight in the middle right pane is the one that displays in this pane.

The SQL Text tab displays the text of the SQL statement.

The SQL Information tab displays two SQL Information panes, one for the SQL information before the analysis and one for the SQL Information with the parameter changes.

Create/Drop Indexes button

Displays the script for creating and dropping the index sets. Click Execute $image\B_Execute.gif$ located at the right of the Index Impact Analyzer window to create the new index or drop the index.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

SQL Optimizer for SAP ASE 3.9 - User Guide

Index Impact Analyzer Window