Subject Re: [firebird-support] Re: Question about PLANs
Author Arno Brinkman

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

Arno Brinkman

Firebird links :

Nederlandse firebird nieuwsgroep :