Prioritize Missing Index Recommendations 2 (2005)

  • Michael L. Smith

    SSC Enthusiast

    Points: 102

    Comments posted to this topic are about the item Prioritize Missing Index Recommendations 2 (2005)

  • Mike Good

    SSCertifiable

    Points: 7388

    Thanks for posting this! Good work.

    I just ran across it today. Results correlate very well with results from some other "worst performing procs" queries I run, and sure enough the recommendations are spot on. I know, I shouldn't be surprised.

    I'm still inspecting the top recommendations pretty closely before deciding what to do, if anything. Not sure what I'll do once I begin to fully trust this stuff.... Do you still inspect the related procs/queries and craft the each index creation script carefully?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply