Now after 12+ more year using interbase I cannot recall
any situation to recompile procedures or triggers ...
beside a corruption or damage of tables.
and I do't think this will be next years...
Claus

---------- Original Message ----------------------------------
From: "Robert DiFalco" <rdifalco@...>
Reply-To: firebird-support@yahoogroups.com
Date: Sat, 7 Aug 2004 09:27:57 -0700

>Is there any value in periodically recompiling Stored Procedures and
>Triggers? I have a scheduled task that periodically recomputes index
>selectivity. I noticed that IBExpert has the ability to recompile Stored
>Procedures and Triggers and am now wondering if I should do that as well
>in my maintenance task.
>
>If so, what is the best way to do this? I suppose there is a query to
>get all of them and add ALTER to them all and re-execute them? Anyone
>have details on this? Maybe it is in Helen's book, but that book is SO
>BIG.
>
>TIA!
>
>R.
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>