The SQL Selector workflow allows you to choose original SQL from a batch of SQL statements.
To select original SQL using SQL Selector for Plan Control
Enter SQL statements in the Alternative Details pane of the SQL Details tab.
Select a connection.
The SQL Selector window displays your SQL statements.
The SQL list displays in the control grid on the left. When you select one of the SQL statements, the corresponding SQL text is highlighted in the right grid.
The buttons on the user interface change accordingly if the selected SQL statement has a variable(s) or temp table(s). Review the following for additional information:
|If the SQL statement…||the user interface displays…|
|Does not contain a variable||
Click the OK button to use the selected SQL as the original SQL statement.
|Contains a variable(s)||
To enter bind variable values
Note: Click to return to the SQL list to select a different SQL as the original SQL statement.
|Contains a temp table(s)||
To create temp tables
Note: After you select the original SQL statement, the whole text is kept as the Batch Scope for a plan guide.