Ryan D. (8/27/2009)
Thank for the reply, the issue I'm having is that the report is showing about 200 missing/recommend indexes. Based upon the different column values, which one should be looked at in the order of importance.
You more than likely will not need to implement all of the "missing" indexes shown in the report. Sometimes the report will show multiple indexes for the same thing.
As Grant has mentioned, there are scripts here on SSC for determining which indexes might be of more use than others (based on cost/benefit).
Just Browse the Index Management section of the scripts area here at SSC - or do a search for index scripts. There are several scripts that could be of use.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events