Join GitHub today
GitHub is home to over 50 million developers working together to host and review code, manage projects, and build software together.
Sign upSQL - indicate if Query has Missing Index recommendation #314
Comments
|
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. |
|
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. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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)