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