You can generate a resolution report for a SQL Rewrite or Plan Control session after you generate execution plan alternatives. The resolution report includes the following:
Tip: You can also export the contents of a SQL Rewrite grid (or other grid) to an Excel file. Right-click the grid and select Save As | Excel Document. Other file formats are also available.
To generate a report
Use the report window to customize the layout and the information displayed in the report, and to select publishing options. Use the following Report toolbar buttons.
|Current Settings. Click to specify the information to include in your report.|
|Page Setup. Click to modify margins and select page orientation.|
|Scale. Click to adjust the scale of the printed output.|
Watermark. Click to add a watermark to the report.
|Color. Click to change the report background color.|
Export Document. Click to save the report to file using the default format. Click the arrow to select from several file format options (or to change the default setting).
You can select from several different file formats, including PDF, HTML, and Excel.
|Send via Email. Click to save the report to file using the default format and to also attached the file to an email. Click the arrow to select from several file format options (or to change the default setting).|
Note: To select SQL or plan alternatives to include in the report, click and then click Select Alternatives. Select alternatives from the list.
To export the report as a PDF file
In a Plan Control session, deploy an execution plan as a plan baseline to the Manage Plan module.
To deploy a baseline
Select a plan to deploy
|Click and select an execution plan alternative to deploy as a baseline plan.|
|Use this to review the performance of selected plans against the original.|
Mark the plan as
Review the following for additional information:
|Enter a name for the plan.|
|Enter a description for this plan.|
Use Optimize Indexes to analyze and improve indexes for a SQL workload or for any group of SQL statements. You can instruct SQL Optimizer to gather SQL from an application workload during a specified time period. SQL Optimizer evaluates your SQL workload and provides you with the best set of indexes to optimize database performance for that workload. After this evaluation process is complete, you can review the results and then select the new indexes you want to save and test.
Note: To optimize indexes for a single SQL statement, use Optimize SQL. See About Optimizing SQL (SQL Rewrite) for more information.
You can instruct SQL Optimizer to gather a SQL workload from any of the following sources:
After collecting the statements, SQL Optimizer provides you with the execution plans and run-time statistics. Select the statements for which you want to optimize indexes. After running the evaluation process, review the results to determine the performance improvements. If, after reviewing the results, you choose to add new indexes, you can perform an Index Impact Analysis to determine the impact (of creating the indexes) on database performance.
The following is a summary of the Optimize Indexes workflow:
Things to consider when using Optimize Indexes:
When evaluating your SQL workload, SQL Optimizer creates virtual indexes. No indexes are created, so this process does not significantly affect database performance. Also, the Index Impact Analysis process uses virtual indexes to evaluate the impact on database performance.
Note: You can use Optimize Indexes only when connected to an Oracle 8i (or later) database.
Go to Step one. See Select a SQL Workload Source.