> > 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.

Hmmm... ok - not _that_ sure.

What I wanted to say was, that the plan is not stored upon creation
of the procedure (or anything like that).

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com