Re: Use of sys_context changes execution plan

Paul Ansell wrote:

> I have a dynamically generated query which when executed with
> hard-coded where clause values uses an execution plan that I am happy
> with. However, when I replace the hard-coded values with calls to
> sys_context ( in order to make use of bind variables ) a different,
> inferior execution plan is chosen. Any ideas why this should happen?

Have you tried using a hint to help the CBO make the better choice?

Daniel Morgan Received on Fri Jul 05 2002 - 11:26:18 CDT