• New persopn (4/15/2013)


    1) what is the difference between current execution plan and actual execution plan

    Depends what you mean by 'current execution plan', as that's not a common term

    2) on which parameter based we can find it

    If you mean the parameter values that the plan was compiled with, that's in the plan, should be in the properties of the select operator.

    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