Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Small doubt Expand / Collapse
Author
Message
Posted Monday, April 15, 2013 10:11 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 10, 2016 11:35 PM
Points: 210, Visits: 631


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
Post #1442570
Posted Monday, April 15, 2013 11:42 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: 2 days ago @ 5:27 AM
Points: 44,614, Visits: 42,370
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

Post #1442586
Posted Tuesday, April 16, 2013 12:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 10, 2016 11:35 PM
Points: 210, Visits: 631
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

Post #1442606
Posted Tuesday, April 16, 2013 11:56 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: 2 days ago @ 5:27 AM
Points: 44,614, Visits: 42,370
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

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

Post #1442904
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse