plan cache and internal hints - by Michel.priori

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<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 780038 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 2/26/2013 8:52:44 AM
Access Restriction Public


Sometimes a query is not fully optimized by the optimizer because of time out.
Ok with that.
In general it's associated with a in production query.
The second execution may re-use the uncompleted plan.
Sign in to post a comment.
Posted by Microsoft on 4/12/2013 at 2:18 PM
After carefully evaluating all of the suggestion items in our pipeline, we are closing items that we will not implement in the near future due to current higher priority items. We will re-evaluate the closed suggestions again in the future based on the product roadmap.

Thanks again for providing the product suggestion and continued support for our product.

Umachandar, SQL Programmability Team
Posted by Microsoft on 4/12/2013 at 1:00 PM
Hello Michel,
We are currently evaluating improvements that will help with this sort of problem, although not necessarily via the approach you outline here.
Unfortunately at this time we cannot commit to any changes in the next release.
Thanks very much for your suggestion.