plan cache and internal hints by Michel.priori

Resolved

as Won't Fix Help for as Won't Fix

Type:	Suggestion
ID:	780038
Opened:	2/26/2013 8:52:44 AM
Access Restriction:	Public

Workaround(s)

view

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.

Details (expand)

English

SQL Engine

1- Mark this plan as uncompleted one
2- If the plan is still in cache, continue the initial work
3- In a maintenance window, take time to complete
4- Once it's complete, produce associated hints for futher use

5- Give the oportunity to manualy update this "internal hints"

Improved Performance

The Hints are not maintainable as recorded in the calling code. Associating them externally allows easy and elegant maintenance.
SQL scripts will be more refined of Hints.
Internal management allows find obsolete Hints in the event of changes in indexes.

0 attachments

Posted by Microsoft on 4/12/2013 at 2:18 PM

Hello,
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.

Microsoft