Generating access path reports

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.

Before you begin

Procedure

To generate access path reports, follow either of these steps:

Results

The reports are displayed in the Review Access Path Reports page of the Review section.

Feedback