Note: I do not suggest changing already cached plans yet.
I suggest looking into "6th bind values" when building a cached plan.
In other words, "if first 5 execution do not reveal dependence on bind
values, then cache the generated plan".
>Say you already have a plan which looks like this:
>Now the plan gets invoked with $1 = 5. What exactly in your mind would happen here?
A sequential scan with $1=5 condition. What else could be there?
Vladimir
