What server makes work several times faster after I recompile all SP and triggers? We have 500mb db with 700 triggers and SP.

--- In firebird-support@yahoogroups.com, "Martijn Tonies" <m.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".
>
> 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
>