Post reply

Apply query execution plan in SQL Server 2000 query in SQL Server 2008 R2

  • September 28, 2012 at 10:50 am

    #393278

    Hi All,

    Could I take a query execution plan in SQL Server 2000 and apply it in SQL Server 2008 R2 in the same query?

    Regards,

    Antonio Estima

  • September 28, 2012 at 11:20 am

    #1543558

    No.

    The only way to 'give' an exec plan to a query is using the WITH PLAN hint, it requires the XML form of the plan. SQL 2000 does not give XML versions of the plans, that feature was introduced in SQL 2005.

    Besides which, forcing plans is not a good thing to do unless you know exactly why the plan you are recommending is and always will be better than what the optimiser comes up with.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply