SQL Optimizer for SAP ASE 3.8

You can filter the SQL statements displayed on the Time tab and the Statistics tab of the SQL Optimizer window by any of the run time statistics after you have executed the SQL statements so that the run time statistics are displayed on the Time tab and the Statistics tab.

The current filter displays in the bottom left corner of the Time or Statistics pane.

To filter the SQL statements

Click the downward pointing arrow to the right of a column heading.
Select one of the following:

Item	Description
All	Displays all the SQL statements.
Custom…	Opens the Custom AutoFilter window where you can select the options for filtering the SQL statements based on specific values for the selected column.
Blanks	Select all the SQL statements which do not have a value in the selected column.
NonBlanks	Select all the SQL statements which do have a value in the selected column.
Specific Value	Select all SQL statements that have one specific value.

You can repeat steps 1 and 2 to add as many filters as you would like.

To clear the filter

Click $image\B_ClearFilter.gif$ at the bottom-left corner of the Time or Statistics pane.

Find SQL Using a Text String

SQL Optimizer > Optimized SQL > Find SQL Using a Text String

The Find SQL function is available in the SQL Optimizer window. This enables the location of SQL statements that contain a specified text string.

To find text in a SQL statement

Select SQL | Find SQL to open the Find SQL window.
Enter the text string to be found and click Find.
To continue searching for the same text, select SQL | Find Next SQL [Ctrl + F3].

Generate a Report for Optimized SQL

SQL Optimizer > Optimized SQL > Generate a Report for Optimized SQL

The details of the SQL statements and run time results in the SQL Optimizer window can be generated into a report.

To generate the Optimized SQL report

Select Report | Optimized SQL to open the Optimized SQL Report Criteria window.
Select the components for the report.
Select All SQL or Select SQL and enter the specific SQL statement numbers.

Note: A few minutes may be needed to generate a long report.

Verify Correctness of Optimized SQL Statements

SQL Optimizer > Optimized SQL > Verify Correctness of Optimized SQL Statements

You can verify the correctness of optimized SQL statements by comparing it with the original SQL statement using the Run Result function and by looking at the No. of Records column in the Time tab in the SQL Optimizer window after retrieving the run time. This information enables you to see whether the optimized SQL statement provides the same results as the original SQL statement.

Run Result

The Run Result function retrieves the queried records from the connected database.

Number of Records

In the Run Time pane of the SQL Optimizer window, the No. of Records displays the total number of records influenced by the SQL statement. This figure should remain constant for both the original and optimized SQL statements.

First Record

In the Run Time pane of the SQL Optimizer window, the First Record indicates the first record retrieved either 0 or the number of records that was selected for First n Records in the Run Time Mode page in the Batch Run Criteria window . This figure should remain constant for both the original and optimized SQL statements.

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.8 - User Guide

Filter Run Time Results