When you run the single-query advisors on an SQL statement,
you can summarize their recommendations in a report. The report also
lists information about the access path for the SQL statement and
catalog information about the relevant tables, columns, and indexes.
Procedure
To generate a summary report:
- Capture the SQL statement that you want
to tune. See Locations from which you can capture
an SQL statement for single-query tuning.
- Select one of the captured statements
and click the Invoke Advisors and Tools button.
The Run Single-Query Advisors and Analysis Tools page
in the Invoke section opens.
- If you need to set the schema
to use for unqualified objects that the SQL statement references,
or (if the statement runs on DB2 for z/OS) change the SQL ID, specify
these values in the Schema and SQLID fields above the SQL statement
on this page. For information about setting global defaults for schemas
and SQL IDs, see Setting the schema to use for unqualified
objects, the SQL ID, or both.
- Click the Select What
to Run button.
- Select the types of recommendations that you want to generate.
- In the Select Activities window, select Summarize
and report recommendations. 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 also right-click
the report and select the option for printing it.