After you have saved the SQL and index-set alternatives to a file, you can load them and their test results back into the SQL Optimizer window.
To reload the saved alternatives
Select SQL | Open Optimized SQL.
Select the file you want to load and click Open. This loads the saved alternative into the SQL Optimizer window.
The Open Optimized SQL Details window displays the following:
Displays the original connection and optimization settings information.
Displays the saved and current connection information and whether there are any changes in SQL structure and access plans.
If the SQL statement uses a temporary table, the User-Defined Temp Table tab appears in this window. It displays the DDL used to create the temporary table.
If there are any changes to the SQL structure or the access plans, the Changes tab appears in this window. It displays the SQL text along with the saved and current access plan.
If there are any changes in SQL structure or access plans, you should refresh the access plans so that the reloaded image is a truth reflection of the current environment before any further testing is done.
To refresh the execution plans
Click Refresh Plan from the Open Optimized SQL Details dialog.
If there are changes in the access plan the corresponding SQL statements run time information is deleted. All invalid SQL statements are removed, except for the original SQL statement. You have an option to eliminate SQL statements with duplicate access plans.
After refresh, the Refresh Plan Details dialog can be displayed. This dialog displays the number of access plans refreshed, the total eliminated, and the total invalid plans.
To review the Open Optimized SQL Details dialog anytime
Select View | Show Open Rewrite SQL Details.
To review the Refresh Plans Details dialog anytime
Select View | Refresh Plan Details.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
