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.


Cheers,

Ann