Subject Re: Question about PLANs
Author José Lacerda

Thanks for your replay.

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

Thanks in advance,


José Lacerda
UTILsoft, Lda