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 blue checkmark at the left of the row indicates the SQL statement is selected.
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.
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 or
.
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.
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, is enabled at the bottom right of the window.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center