Subject FW: Recomputing index statistics and stored procedures
Author Rick Debay
As data changes, a stored procedure's plan will degrade. Can a
mechanism be exposed to flush stored procedure plans?

-----Original Message-----
[] On Behalf Of Ann W. Harrison
Sent: Tuesday, June 21, 2005 2:31 PM
Subject: Re: [firebird-support] Recomputing index statistics and stored

>> When a stored procedure or trigger is compiled, are the plans for its
queries chosen at that time?
>> If so, they should be recompiled after recomputing index statistics.
>>In that case, does anyone know how to recompile all stored procedures
and triggers
I thought that the plans were chosen when the procedure was first
invoked and retained by the server until the database is closed.
And I don't know of a way to force a recompilation except to alter the
procedure to itself.