You can generate a report that
contains a summary of the
tuning recommendations for an SQL statement, a summary of the access
plan, catalog information for referenced tables for a single query,
DDL statements for creating recommended indexes, and recommended RUNSTATS
commands.
Procedure
To generate a summary report, follow
either of these
steps:
- Click Generate Summary Report on
the left side of the Invoke section.
- Click Select What to Run on
the Run
All Single-Query Advisors and Analysis Tools page. In the Select
Query-Tuning Activities window, select Summary
Report and any of advisors from which to include recommendations
in the report. Then, click OK.
Results
The report is generated in HTML and displayed
in the
Open
Summary Report page of the
Review section.
If you want to save the report to your filesystem, click the
Save
Report button at the top of the report. You can then share
the report with other people.