>>Check
http://sqlserverperformance.wordpress.com/2011/02/04/five-dmv-queries-that-will-make-you-a-superhero-in-2011/>
>Thanks, so is it that the execution plan information that we see when we move the mouse over an object does not content related information as to which fields we would need to include in order to be optimized?
>
>I see that the second script at
http://sqlserverperformance.wordpress.com/2011/01/06/sql-server-index-tuning-for-mere-mortals gives me five records and I can see there is an Included_Columns field. Are those the fields that are suggested to be included in the index I was refering to?
>
>I see also that the fourth script gives me suggestions on new indexes to add. Basically, it is making reference to the same index but with a different set of included fields.
>
>So, basically, are those scripts better to identify which index need to be adjusted in regards to the included fields as well as which one I need to create instead of analyzing the execution plan?
The scripts by Glenn Berry make use of the DMV views and they are based on the statistical information. I'd say, they can be trusted.
If it's not broken, fix it until it is.
My Blog