Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - Installation Guide

Right Pane for SQL Statements

In the Index Impact Analyzer window, when a SQL statement 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 database settings at the time of the analysis.

SQL Information button

Displays the SQL statement selected, as well as, two SQL Information panes that show the query plans for the statement before and after the index Scenario is in place. In the query plan, the operations that are different between the two plans are highlighted in green.

Saving the Abstract Plan

The abstract plan for a SQL statement can be saved from this pane. In order to save the abstract plan, it must be retrieved when the SQL was selected to be analyzed. This is done from the Abstract Plan page of the New Analysis wizard.

  1. Select the SQL statement in the left pane.

  2. Click SQL Information section of the right pane. This enables the Save Abstract Plan button.

  3. Click Save Abstract Plan image\B_SaveAbstractPlan.gif.

  4. In the Save to group field, select the abstract plan group.

  5. Click Save.

 

Related Topic

Related Documents