SQL Optimizer for SAP ASE 3.9 - Installation Guide

Optimize Original SQL Statement

If sending a SQL statement from the SQL Scanner, SQL Worksheet, Database Explorer, or SQL Formatter to the SQL Optimizer (Edit | Send to SQL Optimizer), these statements are automatically optimized.

To optimize a SQL statement

1. In the SQL Optimizer window, enter the SQL statement in the SQL Editor pane of the SQL Optimizer.

2. Click .

The time it takes to optimize is dependent on the complexity of the original SQL statement and the quota values set in the Preferences window.

During optimization, the unique optimization engine uses multiple SQL syntax transformation rules to produce a list of semantically equivalent SQL statements. Selected optimization forces from the Preferences window are also applied to produce the list of optimized SQL statements.

To stop the optimization process

Click .

It may take a few seconds to terminate all processes.

Note:When setting the searching quota values that, the higher the quota, the longer it may take to optimize a complicated SQL statement.

Related Topic

Optimize Using Abstract Plan Only

SQL for Cursor Checkbox

Open Optimized SQL

SQL Optimizer Window