number of binds changing execution plan
In my case there are 3 bind variables in query which runs in 11 sec If I replace a literal with bind variable resulting in 4 bind variables the sqlid changes and so is the execution plan.
Can we prevent such things to happen?
Regards,
Vishal