Post reply

Query execution plan

  • June 17, 2015 at 3:45 am

    #309286

    Hi Guys,

    Is it possible to check query execution plan of a store procedure from create script (before creating it)?

    Basically the developers want to know how a newly developed procedure will perform in production environment. Now, I don't want to create it in production for just checking the execution plan. However they've provided SQL script for the procedure. Now wondering is there any way to look at the execution plan for this procedure from the script provided?

    Thanks.

  • June 17, 2015 at 3:48 am

    #1805986

    Please don't cross-post

    No replies here please, replies to http://www.sqlservercentral.com/Forums/Topic1695235-391-1.aspx

    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 2 (of 2 total)

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