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.

제품을 선택하십시오.

더 나은 서비스 제공을 위해 채팅 목적을 작성해 주십시오.

문제에 대한 권장 솔루션

SQL Optimizer for SAP ASE 3.8 - User Guide

Filter Run Time Results