Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

Right Pane for SQL Statement

Configuration Analyzer > Configuration Analyzer Window > Right Pane for SQL Statement

The detailed information about the SQL statements used in the Analysis displays in the button pages. The buttons for displaying specific information are found at the top of this pane.

Properties button

Displays general information about the SQL statement and the database settings at the time of the analysis.

SQL Information button

Displays the SQL text in the top portion of the right pane and two SQL Information panes, one for the SQL information before the analysis and one for the SQL information with the parameter changes, in the bottom right pane.

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

Create a Configuration Analysis

Create a Configuration Analysis

Configuration Analyzer > Create a Configuration Analysis > Create a Configuration Analysis

To create a Configuration Analysis:

  1. Click to open the Configuration Analyzer window.
  2. If no analysis exists in the Configuration Analyzer then the New Analysis wizard displays automatically. Otherwise, click to open the New Analysis window.
  3. The New Analysis wizard has three pages for selecting the options for creating an analysis:

    Page See...
    Analyzer New Analysis Wizard: Analyzer Page
    Selected SQL New Analysis Wizard: Select SQL page
    Configuration New Analysis Wizard: Configuration Page
    Abstract Plan New Analysis Wizard: Abstract Plan
  4. After making your selection, click OK.

To abort the Configuration analysis

Select Analysis | Abort Analysis.


Related Topics

New Analysis Wizard: Analyzer Page

Configuration Analyzer > Create a Configuration Analysis > New Analysis Wizard: Analyzer Page

The Analyzer page is used to name the analysis and to select the folder where the SQL statements that you want to analyze are stored.

Creating a new Analyzer and select SQL to be analyzed

Select this option to create a new analysis using a different set of SQL statements.

Continuing an existing Analyzer using the Analyzer's selected SQL

Select this option to use the same set of SQL statements that is stored in an existing Analyzer. This option adds another Scenario under an existing Analyzer and does not retrieve a new set of query plans for the SQL statements. It uses the query plans that were originally saved with the SQL statements.

Do not rollback changes to the ASE configuration parameters

Specific to leaves the database configuration changes that you select under the Configuration tab after the analysis is finished. Otherwise, these changes are rolled back at the end of the analysis processing. After the analysis is complete, the Apply/Undo Changes button displays at the top of the Configuration Analyzer window which displays the Apply Changes and the Undo Changes panes. These panes contain the scripts to make changes to the Adaptive Server configuration parameters.

Item Description


Enter the name for the analysis.


Enter the description for the analysis.

Last modified

Displays the last modified date and time.

Save location

Displays the folder in the tree where the analysis is saved. In the bottom pane, select the folder where you want to save the analysis. To create a new folder, click Add Folder image\B_AddFolder.gif.


Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating