I have SQL Server 2005. I want to know how can i fix and change execution plan of stored procedure or user defined function?
Also, want to know, if already I fix excution plan, when automatically it gets changed, and what to do to avoid it.
I have stored procedure, which run several times in an hour (lets say 500-800 times in an hour), i have observered that execution plan gets changed frequently. So, if i can fix execution plan, than i can take maximum advantage of indexes i created.