Sean Lange (1/10/2014)
Stale statistics?Parameter sniffing (or the lack of it)?
It is nearly impossible to help without some details. Please see this article from Gail about how to post performance issues. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]
Parameter sniffing cannot occur in my case because it is simple update query .....
and we did update statistics but it was also not hepfull 🙁