Hi,

> "The optimizer recalculates plan on every statement thus if content
> has changed then the PLAN can change too."
>
> If the plan can change frequently (Because the contents of the tables
> will change continuously), this statement shouldn't be used inside a
> Stored Procedure. AFAIK, the plan will be defined when the SP is
> created and, in this case, the selected plan couldn't be the most
> adequate. Is this correct ?

No, when NO PLAN is forced in the Stored Procedure then the PLAN is
calculated before execute and this is what you always want.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81