Bugs in applications & pinned plans in queries
Bugs in applications & pinned plans in queries At my place of work, one of the ways non optimal plans are handled , is by gathering stats. The other method is to use SQL profiles, by ‘pinning’ plans to queries. Oracle also supports SQL baselines another method of doing a similar thing. This leads to problems as plans which work today, might not work two years down the line. (Think table stats evolution over time)....