When a workload is created or an index analysis completed, a series of reports are generated. This section gives a brief overview of each report. For more about reports, see Chapter 7: “Reports.”
1 Select Reports > Current Workload.
A new window opens with the available reports shown on the left side of the window.
2 Click a report name to view the report.
The following table briefly describes each report and shows its associated tree menu icon.
|
Icon |
Report Name and Description |
For More Information |
 |
Index Recommendations Report Displays information about the recommended set of indexes for the tables in the workload. |
|
 |
Existing Indexes Report Displays information on the existing set of indexes for the tables in the workload. |
|
 |
Query Cost Analysis Report Displays the execution cost improvement for the SQL statements with the recommended set of indexes. |
|
 |
Update Frequency Report Displays the relative number of updates on a given table in the workload when compared to the number of accesses from the table. |
|
 |
Disk Space Analysis Report Displays the estimated space required to store the recommended indexes. |
|
 |
Index Maintenance Cost Report Displays the estimated cost of maintaining recommended indexes for a particular recommendation ID on a workload. |
|
 |
Table Usage Analysis Report Displays the usage of tables within the workload. |
|
 |
Table Scan Report This report contains information about the usage of tables in the workload. It aids the user in selecting tables over which the set of indexes will be recommended. Table cardinality (estimates), access types, and geographies can give clues as to where an index might be of value. |
|
 |
Object Global Use Count Report Shows the objects that are accessed the most on a table. |
|
 |
Workload Analysis Report This report provides a statement-wise analysis of the workload. |
|
 |
Summary Report This report shows details about the secondary index count and recommendation count made in a specific analysis for all tables in a workload. |
Go to the next step, “Validating Recommendations” on page 44.