SQL - indicate if Query has Missing Index recommendation

[elvishfiend]

A quick way to tell that a query may be tuneable is if there's a Missing Index recommendation in the SqlPlan.

There's currently no indication of this either in the SQL Top Queries page or on the Query Detail itself, but it would be helpful to at least have an icon on the Top Queries page showing that there's something worth looking into. (I know that Index recommendations can be junk - that's why I'm only suggesting an icon)

[NickCraver]

Are you picturing an icon on the individual query results, or on the main listing? Just trying to understand the desire here. On the main listing would be very costly, as it would require bringing back the entire pain and shredding the XML to determine the boolean. In the detail window: it's much more doable.

[elvishfiend]

I had originally pictured it on the main listing - but then I went and had a look at doing it myself, and I see what you mean about the pain. I think having it in the Query Detail will be a big enough win - you see a slow plan, you open it, "Possible Missing Index!"