Subject RE: [firebird-support] Recompiling Triggers and Procedures?
Author Helen Borrie
At 01:36 PM 7/08/2004 -0700, you wrote:
>I'm assuming you would have a performance increase if you added indices
>after creating the stored procedure or trigger that they could take
>advantage of. Otherwise nothing?

Adding indexes after compiling a SP or trigger module won't affect the
module. The effect will be on optimisation, and optimisation occurs at
run-time, not when the module is compiled.

That said, as part of a tuning exercise, you might *want* to visit a
module's source and see whether some recoding of queries within will
improve performance. Because index usage for PSQL modules occurs on
SELECTS inside the module, you may well want to explore a better way to
extract data inside a module.