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.