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
-
Click
.
-
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.)