At 02:36 PM 12/17/2001 +0000, Nick Upson wrote:

>I understand that IB creates a plan for queries inside an SP or VIEW
>at the time it's created, if the data then changes considerably when
>does the plan get modified?

The plan for a procedure is created when the procedure is first
evoked by a newly started server. The plan for a view is created
each time the view is referenced in a statement - and saved in
prepared statements of course.

So the answer for procedures is each time the server restarts
and the answer for views is even more often.


Regards,

Ann
www.ibphoenix.com
We have answers.