2012年2月19日星期日

disable recompile

Sometimes our stored procedures recompile and they get a poor query plan.
How can one stop the stored procs from recompiling ?Possibly investigate the KEEP FIXEDPLAN optimizer hint. But read
http://msdn.microsoft.com/library/en-us/dnsql2k/html/sql_queryrecompilation.asp and
http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx first.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Just Me" <justme@.hotmail.com> wrote in message news:e3PdX787FHA.720@.TK2MSFTNGP10.phx.gbl...
> Sometimes our stored procedures recompile and they get a poor query plan.
> How can one stop the stored procs from recompiling ?
>

没有评论:

发表评论