Table Usage Analysis Report
The Table Usage Analysis Report shows information on how often the table is accessed within the workload. A table with a high access number may have more potential for an index improvement. On the other hand, a table with a low access number may not need to be analyzed because its potential for a performance gain is limited. This report is created when a workload is defined or after the index analysis process.
To open the Table Usage Analysis Report
✔ Select Reports > Current Workload > Table Usage Report.
The following table explains the information provided by this report.
|
Column Name |
Description |
|
Database Name |
Shows the name of the database. |
|
Table Name |
Shows the name of the table. |
|
Statement Access Count |
Indicates the number of statements in the workload that access a specific table. |