Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL - indicate if Query has Missing Index recommendation #314

Open
elvishfiend opened this issue Feb 27, 2018 · 2 comments

Comments

Projects
None yet
2 participants
@elvishfiend
Copy link

commented Feb 27, 2018

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

This comment has been minimized.

Copy link
Member

commented Jun 12, 2018

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

This comment has been minimized.

Copy link
Author

commented Jun 12, 2018

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!"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.