|Subject||Re: Recompile triggers and SP|
Thank you for explanation. Perhaps recompiling SP and triggers was just a coincidence for performance boost.
--- In email@example.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
> With regards,
> Martijn Tonies
> Upscene Productions
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
> Database questions? Check the forum: