Subject Re: [firebird-support] Recompile triggers and SP
Author Ann W. Harrison
Martijn Tonies wrote:
> Hi,
>> How can I recompile SP and triggers to update execution plan according new
>> index selectivity. I need to make my application to do that.
> Execution plans aren't stored, they are generated "on the fly".

Err, actually no. Or yes. Or it depends. Execution plans for
procedures aren't permanent unless they're explicitly defined by
the creator of the procedure. On the other hand, once a procedure
has been used by a server instance (meaning the server in SS and
the connection in CS), its executable version is kept in memory.