To deploy an outline
Select the Optimize SQL tab in the main window.
Select a SQL Rewrite session.
Right-click the alternative you want to deploy as an outline in the Alternatives pane and select Deploy Outline. The Deploy Outline window displays.
Review the following for additional information:
|Outline name||Enter a name for the stored outline.|
Click and select a previously created category or enter a new category name.
Note: The default category name is SQL_OPTIMIZER.
The Deploy Outline function is only available for SQL Rewrite sessions in Optimize SQL.
SQL Optimizer integrates with other Toad applications. You can send SQL from other Toad applications to SQL Optimizer in order to optimize the SQL statement.
In addition, after optimizing a SQL statement in a SQL Rewrite session, you can send an alternative SQL statement back to the original application.
To send an alternative SQL statement back to the original application
After you optimize the original SQL statement and determine the best alternatives, you may find the performance of the selected statements unsatisfactory in your database environment.
To remedy this, check if SQL Optimizer has reached any of the optimization quotas for your original SQL statement. Select SQL Information in the Execution Plan pane and select Alert to view this information. Make adjustments to the intelligence, optimization, hints, or quota setting options if SQL Optimizer has reached any of the quotas. To access these settings, click and select Optimize SQL | Optimizer.
Additionally, review the execution plan of the original and optimized SQL statements to check if you need to change the database structure.