There are four statistics views. The descriptions and how to browse to each view are listed in the following table.
| View | Description | Navigation from Home |
|---|---|---|
| Statistics by Database | View statistic information on all databases on a system and access system-generated recommendations. | Click the Statistics tab to see the Statistics by Database view. |
| Statistics by Object | View statistic information on objects, such as tables, for a single database. | From the Statistics by Database view, click a row in the table to see the Statistics by Object view. |
| Statistics | View statistics information for a single object, such as a table or index. | From the Statistics by Object view, click a row in the table to see the Statistics view. |
| Statistic Details | View details and collect settings for a single statistic. | From the Statistics view, click a row in the table to see the Statistic Details view. |
Depending on the view, the following features are available:
-
Actions - Automate enables statistics to be collected by collect jobs. You can automate a system, database, object, or single statistic.
- Information Bar
- % of stats approved for automation displays the percentage of statistics that are approved for automation, allowing you to determine if more statistics need to be approved for automation.
- Recommendations Link
- Displays a list of the recommendations when the link is clicked, allowing you to approve or reject recommendations.
- Filters
- Shows only rows that match your filter criteria.
Table Actions- Clear Filters removes any content in the filter boxes.
- Statistics Table
- Displays all objects with at least one statistic, or one recommendation that has not been approved or rejected. The table is configured using Configure Columns from the Table Actions list.
Following is an example of the Statistics by Database view.
