Would it be possible to deploy a baseline with the RESULT_CACHE hint added so that results from the SQL will be cached?
Steps to reproduce:
1. Open Plan Control and generate some plans
2. Pick one of the plan to deploy
3. In the deploy screen, note that there is no way to specify a RESULT_CACHE hint in the deployed plan
EXPECTED RESULT:
----------------
There should be a way to specified that the result from this SQL should be cached
Note : RESULT_CACHE is one example, there should be other hints that are not related to influencing the plan and there may be a need to specify them in the deployed baseline.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center