Subject Re: [ib-support] statistics
Author Ann W. Harrison
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.


We have answers.