Help with SQL Tuning Advisor Recommendations
Posted on 2008-10-16
i'm playing around with the Tuning Advisor...
in the index recommendations, i can see where it's recommending an index:
i can see that the index recommendation covers several columns by looking at the Target of Recommendation.
1. how do i know what type of index it is recommending?
2. should i always take the Tuning recommendation? for example, if i'm running the advisor on a query that isn't executed all that often, and the recommendation is to create a covered index on a table, and i have another query that does get executed often and uses different columns in the same table (but not all of the columns in the covered index), could i unintentionally be causing overhead from that covered index when changes are made to the table?
3. the Tuning Advisor is also recommending something called dta_stat. is that statistics, and if so, is it just saying the statistics should be updated?