April 15, 2013 at 10:11 pm
Here i have some doubts
1) what is the difference between current execution plan and actual execution plan
2) on which parameter based we can find it
April 15, 2013 at 11:42 pm
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
April 16, 2013 at 12:25 am
Here I am trying to execute the query and i will find the execution plan
here another option is also available
that is expected execution plan
April 16, 2013 at 11:56 am
http://sqlinthewild.co.za/index.php/2009/02/19/estimated-and-actual-execution-plan-revisited/
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply