Martijn Tonies wrote:

>
> No, the plans are chosen when you execute the procedure or trigger.
>

Are you sure of that? I thought that the plans were chosen when the
procedure was first invoked and retained by the server until the
database is closed.

And I don't know of a way to force a recompilation except to alter the
procedure to itself.

Regards,


Ann