Home Forums SQL Server 2008 T-SQL (SS2K8) Prevent Stored Procedure using bad execution plan RE: Prevent Stored Procedure using bad execution plan

  • November 26, 2015 at 5:05 am

    #1842488

    GilaMonster (11/26/2015)

    sam 55243 (11/26/2015)

    If I do that in case will it prevent this issue from occurring.

    Maybe. And maybe it'll make things worse.

    Does the Recompile hint add an unacceptable CPU overhead to your production server?

    Hi,

    This SP is heavily used and mainly called from an OLTP application so I cant go ahead and add recompile hint. As I have very limited access to live database I couldn't share you the code/plan.