As data changes, a stored procedure's plan will degrade. Can a
mechanism be exposed to flush stored procedure plans?

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

>> 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
[snip]
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.

Regards,
Ann