Plan_handle for the last execution in Missing index DMV:s - by Håkan Winther

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 691085 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 9/27/2011 5:31:30 AM
Access Restriction Public


It would be a great feature if the DMV:s for missing indexes could include a column for the plan_handle of the last execution plan that would have been using the suggested index.
Sign in to post a comment.
Posted by SAinCA on 1/23/2013 at 5:05 PM
OOPS! " to prototype..." not "...unable..."
Posted by SAinCA on 1/23/2013 at 5:04 PM
Not sure why this would be voted DOWN! I'm always needing to know, in a complex environment, the handle that gets me to the query. It's great to know the when and effects (Reads, Writes, savings) but to be unable to prototype with a real query is essential, especially if the query is dynamically generated.
Posted by Microsoft on 9/30/2011 at 9:55 AM
Dear Hakan,

Thanks for the feedback. We'll consider this for a future release.