Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - Release Notes

Selected SQL

The Selected SQL tab is used to select or unselect SQL statements to be executed. All SQL statements are selected by default. The selected SQL statements are displayed in blue. You can select or de-select SQL statements you want to execute by clicking a row. The image\I_BlueCheckmark.gif blue checkmark at the left of the row indicates the SQL statement is selected.

Selecting or unselecting all SQL statements

To select or unselect all the SQL statements

  • Right-click and select Unselect All or Select All.

The original SQL can be de-selected from the list only if the Original SQL checkbox is not selected on the SQL Termination and Batch Termination tab and the Always run Original SQL first option in the Selected Index tab is not selected.

Changing the order the SQL statements are executed

The SQL statements are ranked by Est. I/O Cost by default, with the exception for the original SQL which is placed at the top. You can sort either the Est. I/O column or the SQL column by clicking the column heading.

You can change the order of any SQL statement, by clicking the row and then click image\B_MoveUp.gif or image\B_MoveDown.gif.

Always run Original SQL first

Specify to always run the original SQL statement first despite sort order of the Est. I/O cost. This checkbox is dimmed if the Original SQL option is selected in the Termination Criteria or Batch Termination tab of the Batch Run Criteria window.

Apply SQL selection filter

The SQL selection filter unselects the SQL statements that have an Estimated I/O cost greater that a specified value. When you select this option, image\B_SQLSelectionFilter.gif is enabled at the bottom right of the window.

 

Related Topic

Related Documents