Optimize Original SQL Statement
If sending a SQL statement from the SQL Scanner, SQL Worksheet, Database Explorer, or SQL Formatter to the SQL Optimizer (Edit | Send to SQL Optimizer), these statements are automatically optimized.
To optimize a SQL statement
-
In the SQL Optimizer window, enter the SQL statement in the SQL Editor pane of the SQL Optimizer.
-
Click
.
The time it takes to optimize is dependent on the complexity of the original SQL statement and the quota values set in the Preferences window.
During optimization, the unique optimization engine uses multiple SQL syntax transformation rules to produce a list of semantically equivalent SQL statements. Selected optimization forces from the Preferences window are also applied to produce the list of optimized SQL statements.
To stop the optimization process
Click 
It may take a few seconds to terminate all processes.
Note:When setting the searching quota values that, the higher the quota, the longer it may take to optimize a complicated SQL statement.