zephyr_hex (Megan)
asked on
Help with SQL Tuning Advisor Recommendations
i'm playing around with the Tuning Advisor...
in the index recommendations, i can see where it's recommending an index:
_dta_index_tablename_blahb lah
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?
in the index recommendations, i can see where it's recommending an index:
_dta_index_tablename_blahb
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.