Generating summary reports

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.

Before you begin

Procedure

To generate a summary report, follow either of these steps:

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.

Feedback