If you are using Optim™ Query
Tuner for DB2® for z/OS® or Optim Query
Workload Tuner for DB2 for z/OS, you can generate reports
that show statistics for tables that an SQL statement references,
details about predicates in the statement, and statistics for the
indexes that the access plan uses.
Procedure
To generate access path reports, follow
either of these
steps:
- ClickGenerate Access Path
Reports 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 Access
Path Reports. Then, click OK.
Results
The reports are displayed in the
Review
Access Path
Reports page of the
Review section.