Chat now with support
Chat mit 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

Filter Run Time Results

SQL Optimizer > Optimized SQL > Filter Run Time Results

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

  1. Click the downward pointing arrow to the right of a column heading.

  2. 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.

  1. 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

  1. Select SQL | Find SQL to open the Find SQL window.

  2. Enter the text string to be found and click Find.

  3. To continue searching for the same text, select SQL | Find Next SQL [Ctrl + F3].

 

Related Topic

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

  1. Select Report | Optimized SQL to open the Optimized SQL Report Criteria window.

  2. Select the components for the report.

  3. 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.

 

Related Topics

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.

 

Related Topic

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen