Post reply

Need a help in Stored Procedure execution Plan

  • August 23, 2013 at 6:00 am

    #281562

    If we call more SP inside SP, Does execution plan will create plan for the SP which we called inside main SP as well.

    What would be good idea, whether to call another SP or writing logic in the Same SP as well?

  • August 23, 2013 at 6:03 am

    #1644358

    Each procedure has its own execution plan.

    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