Thank you for explanation. Perhaps recompiling SP and triggers was just a coincidence for performance boost.

--- In firebird-support@yahoogroups.com, "Martijn Tonies" <m.tonies@...> wrote:
>
> Hey Ann,
>
> >>> 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.
>
> So, "cached", not "stored".
>
> Then yes, the advice is to log everyone out so the server unloads the
> database.
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.com
>