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.