Automatically Optimize SQL Statements
Use the Auto Optimize function to perform the optimization and testing processes simultaneously. The function optimizes your original SQL statement by generating alternatives and starts testing once SQL Optimizer generates the first alternative. The Auto Optimize function reduces the time required to find the best alternative by not waiting until SQL Optimizer generates all alternatives before starting the testing process. You can stop the Auto Optimize function once you find a satisfactory SQL statement alternative.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To automatically optimize a SQL statement
- Select the SQL Details tab in the main window.
- Enter a SQL statement in the Alternative Details pane.
-
Click
.
Tip: Click
to stop the optimization and testing processes.