Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - 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

Modify a Configuration Scenario

You can only modify the Scenario name and description of the Scenario.

To modify a Configuration Scenario

  1. Select the Scenario name you want to modify from the left pane.
  2. Right-click and select Modify to open the Modify Scenario window.
  3. Modify the name and/or description.


Related Topic

Configuration Analyzer Functions

Below is a list of available functions within the Configuration Analyzer window.




Right-click Menu

New Analysis/Abort Analysis Create a Configuration Analysis

Right-click Menu

Add Folder


Right-click Menu

Add Scenario

Add a Scenario

Right-click Menu


Add SQL to a Configuration Analysis

Right-click Menu


Regenerate a Configuration Scenario

Right-click Menu


Modify a Configuration Analysis

Right-click Menu


Rename a Configuration Analysis or Scenario

Right-click Menu


Delete a Configuration Analysis or Scenario

Right-click Menu

Go To Undo Changes

Rollback Changes to Configuration Parameters

Right-click Menu

Confirm Changes

Rollback Changes to Configuration Parameters

View Menu

Last Configuration Analysis Details

View Configuration Analysis Details


Related Topic

Migration Analyzer

Migration Analyzer Overview

The Migration Analyzer evaluates the effect on SQL performance when migrating to another database or Adaptive Server version. It enables you to analyze whether the SQL performance is going to improve or degrade by simply making a connection to the new database and viewing how query plan information will change for your selected SQL statements without physically having to execute the database applications in the new Adaptive Server version. The Migration Analyzer compares the query plans from the current database to the query plans that are retrieved from the destination Adaptive Server instance during the Migration analysis to project performance improvement or degradation.


Related Topic

Related Documents