How do I deal with a third party application that has embedded hints that result in a sub-optimal execution plan in my environment?
- by Maria Colgan
I have gotten many variations on this question recently as folks begin to upgrade to Oracle Database 11g and there have been several posts on this blog and on others describing how to use SQL Plan Management (SPM) so that a non-hinted SQL statement can use a plan generated with hints. But what if the hint is supplied in the third party…