SQL Optimizer for SAP ASE 3.8 - User Guide

SQL Optimizer Functions

Below is a list of available functions within the SQL Optimizer window.

SQL Editor Functions

These functions are available only in the SQL Editor.

SQL Editor and Optimized SQL Functions

These functions are available for both the SQL Editor and Optimized SQL.

Optimized SQL Functions

These functions are available only for the Optimized SQL.

Related Topics

SQL Optimizer Overview

SQL Optimizer Window

SQL Editor

SQL Optimizer Window

View SQL Editor Pane in SQL Optimizer Window

The SQL Optimizer window allows you to enter a SQL statement for optimization. The optimization process analyzes the original SQL statement entered in the SQL Editor pane and uses the built-in Feedback-Searching engine to reproduce a list of new, semantically equivalent SQL statements.

The SQL Optimizer supports only a single SELECT, SELECT INTO, DELETE, UPDATE, or INSERT SQL statement. To optimize SQL within Transact SQL, use the SQL Scanner module to identify potential problematic SQL statements within the Transact SQL code. Then optimize each SQL statement in the SQL Optimizer module.

The SQL Editor pane of the SQL Optimizer window is where you input your original SQL statement so that you can optimize it.

SQL Text

The top left pane is used to enter and display SQL statements. The SQL Editor tab allows you to enter the SQL statement you want to optimize. When a SQL statement is copied to this pane from other modules, the optimization process automatically begins.

After optimization, multiply tabs are added to display the optimized SQL statements.

SQL Information

The top right pane [SQL Information] displays SQL information according to the button you select from the button bar at the top of this pane. These buttons include: query plan, abstract plan, and Information (SQL classification and warning messages), All Records, and First Record. The SQL Information Pane provides detailed information about the SQL statement.

Run Time Information

The Run Time information displays in three tabs in the bottom pane.

• Time
• Statistics
• Charts

Related Topics

Enter Original SQL Statement

Optimize Original SQL Statement

SQL Optimizer Overview

SQL Optimizer Functions

Enter Original SQL Statement

The SQL statement that you want to optimize is referred to as the original SQL statement.

To optimize a SQL statement

1. Click .

2. Enter the SQL statement by typing it in, opening an existing file, or pasting it. Parameters within the SQL statement can be prefixed with a "@" sign or without.

To help construct a SQL statement use the member lookup, argument lookup, auto correction, indent, outdent , comment, and uncomment functions.

For SQL statements that involve temporary tables, you need to create the temporary table first before optimizing the SQL statement using the User-Defined Temp Table window.

Only one SQL Optimizer window can be opened at any time. The system will prompt you to save the original SQL statement if you attempt to open another file.

You can perform the following functions from the SQL Optimizer window:

• Retrieve the Query plan
• Retrieve the Run Time for All Records and/or First Record
• Retrieve the Run Result
• Optimize a SQL Statement

Note: The SQL Optimizer supports only a single SELECT, SELECT INTO, DELETE, UPDATE and INSERT SQL statement. To optimize SQL within Transact SQL, use the SQL Scanner module to identify potential problematic SQL statements (e.g. database objects such as Procedures.)

Related Topics

Insert User-Defined SQL

SQL Optimizer Overview

SQL Optimizer Window