The script gives you a starting point for index optimization and you shouldn't follow its results blindly.


>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?