Database Reference
In-Depth Information
Table 10-1.
Database Engine Tuning Advisor Reports
Report Name
Report Description
Column Access
Lists the columns and tables referenced in the workload
Database Access
Lists each database referenced in the workload and percentage of workload
statements for each database
Event Frequency
Lists all events in the workload ordered by frequency of occurrence
Index Detail (Current)
Defines indexes and their properties referenced by the workload
Index Detail (Recommended)
Is the same as the Index Detail (Current) report but shows the information
about the indexes recommended by the Database Engine Tuning Advisor
Index Usage (Current)
Lists the indexes and the percentage of their use referenced by the workload
Index Usage (Recommended)
Is the same as the Index Usage (Current) report but from the recommended
indexes
Statement Cost
Lists the performance improvements for each statement if the
recommendations are implemented
Statement Cost Range
Breaks down the cost improvements by percentiles to show how much benefit
you can achieve for any given set of changes; these costs are estimated values
provided by the optimizer
Statement Detail
Lists the statements in the workload, their cost, and the reduced cost if the
recommendations are implemented
Statement-to-Index Relationship
Lists the indexes referenced by individual statements; current and
recommended versions of the report are available
Table Access
Lists the tables referenced by the workload
View-to-Table Relationship
Lists the tables referenced by materialized views
Workload Analysis
Gives details about the workload, including the number of statements, the
number of statements whose cost is decreased, and the number where the cost
remains the same
Database Engine Tuning Advisor Examples
The best way to learn how to use the Database Engine Tuning Advisor is to use it. It's not a terribly difficult tool to
master, so I recommend opening it and getting started.
Tuning a Query
You can use the Database Engine Tuning Advisor to recommend indexes for a complete database by using a
workload that fairly represents all SQL activities. You can also use it to recommend indexes for a set of
problematic queries.
