SQL Optimizer for SAP ASE - Knowledge Base

Installation Guide > Create an Index Usage Analysis

If no analysis exists in the Index Usage Analyzer then the New Analysis wizard displays automatically. ... Otherwise, click . ... The New Analysis wizard has two pages to select the options for creating an analysis.

User Guide > Index Impact Analyzer Overview

The Index Impact Analyzer analyzes the performance impact of new indexes on SQL statements before the indexes are permanently created on your database. ... New indexes may improve the performance of one SQL but downgrade the performance of several others.

Release Notes > Abstract Plan (SQL Scanner Tab)

The Abstract Plan page on the SQL Scanner tab of the Preferences window allows you to include the retrieval of the abstract plan for the SQL statements. ... Dump abstract plan (Default = cleared)

Installation Guide > New Database Session

The SQL Worksheet uses a different database session to execute the SQL and Transact SQL from the one that was created when you initially logged on. ... It is important to understand how using a different session affects your work in other modules.

User Guide > Introduction to SQL Optimizer for SAP ASE

Quest SQL Optimizer for SAP ASE enables IT professionals to analyze, predict, preempt, diagnose, optimize and manage performance changes to ensure that mission-critical business applications run optimally.

Release Notes > Retrieval Criteria (QP Metrics)

When using the QP Metrics, the Retrieval Criteria page of the Add/Modify Inspector wizard consists of the following settings: ... Target Database ... Specific the database from which to retrieve the SQL statements and the run time statistics.

Release Notes > Monitored SQL Statement Types

The classification settings are found on the SQL Collecting Criteria of the Add Collector wizard. ... Problematic SQL statements are potentially problem SQL statements that should be optimized. ... Problematic SQL must satisfy one of the following criteria:

Installation Guide > Command List

The Command List stores each command that is successfully executed in a drop-down field at the top of the SQL Worksheet window. ... The following functions are available from the right-click menu in the Command List.

Release Notes > Command List

The Command List stores each command that is successfully executed in a drop-down field at the top of the SQL Worksheet window. ... The following functions are available from the right-click menu in the Command List.

Release Notes > Object Extractor Window

Select objects to be extracted [left pane] ... Displays a tree view of all database objects available for extraction. ... Objects to extract [right pane] ... Displays the list of selected objects to be extracted, duplicate objects cannot be added.

User Guide > Modify an Index Usage Analysis

You can only modify the analysis name and description. ... To modify an Analysis ... Select the Analyzer you want to modify from the left pane. ... Right-click and select Modify. ... Modify the name and/or description.

Installation Guide > Copy to SQL Worksheet

SQL statements can be executed in the SQL Worksheet. ... If you are in a module that has a SQL Text pane, you can copy a SQL statement to the SQL Worksheet. ... To copy a SQL statement to the SQL Worksheet

User Guide > Batch Run

User Guide > Delete an Index Usage Analysis

Select the analysis you want to delete in the left pane. ... Right-click and select Delete.

Release Notes > New Analysis Wizard: Select SQL page

The Select SQL page is used to select the SQL statements whose query plans you want to analyze when various database parameters are changed. ... Select SQL to check for performance changes: ... The SQL statements used in an analysis can be taken from the SQL Repository or the SQL Scanner.

Installation Guide > Selected SQL

The Selected SQL tab is used to select or unselect SQL statements to be executed. ... All SQL statements are selected by default. ... The selected SQL statements are displayed in blue. ... You can select or de-select SQL statements you want to execute by clicking a row.

Release Notes > Configuration Analyzer Tutorial

The Configuration Analyzer evaluates the effect on SQL performance when changing Adaptive Server parameter settings. ... It enables you to analyze whether the database performance may improve before you make configuration parameter changes permanent.

User Guide > Add or Modify a Collector

Installation Guide > Drop Indexes

The Index Impact analysis first creates the indexes on your database. ... Then it retrieves the query plan for each SQL statement that you have selected for your analyzer. ... When you set up the individual scenarios, you determine if you would like the indexes dropped or to leave them on your database.

Release Notes > View Group Properties

Review the following for additional information: ... Size ... Number of bytes of disk space used to store the Job information. ... Data Directory ... Directory where the files are stored. ... Version number of SQL Optimizer when the Group was created.

Installation Guide > Parameters within SQL Formatter

If parameters are recognized, they are highlighted in red (default color) after executing the Format function. ... Note: If table names are in maroon (default color) it indicates that the table and corresponding columns are not recognized.

User Guide > Local Variable Conversion

The local variable conversion converts SQL statements that are found in the application source code on one command line and also contain at least one "local variable" which will be replaced by the application before the SQL statement is sent to the server.

Installation Guide > Retrieve Query plan

By examining the query plan, you can see exactly how the database executes your SQL statement, helping you judge whether the SQL statement is the most efficient or any changes to the table structure are needed such as adding a new index.

Installation Guide > View Index Usage Analysis Details

The Index Usage Analysis Details window displays information about the retrieve of the query plan for each SQL statement. ... The Index Usage Analysis Details window displays after the batch run process is completed unless the Show details on next batch run checkbox in the Index Usage Analysis Details window is unchecked.

User Guide > Add SQL to SQL Repository