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.
WORKAROUND
None
STATUS
Enhancement request ST 104,437 has been submitted to Development for consideration in a future release of SQL Optimizer for Oracle
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center