asked on
sql server Execution plan 2012
hi,
Query is running in that wt are the terms i need to notice while execution in execution plan.
How can i understand ? ( physical operation ,Logical operation estimated execution mode,storage like that its showing and also the picture select top like that its showing what is that how can i understand .)
I am attaching my simple one record execution plan.
exec-plan-understand.sqlplan
Query is running in that wt are the terms i need to notice while execution in execution plan.
How can i understand ? ( physical operation ,Logical operation estimated execution mode,storage like that its showing and also the picture select top like that its showing what is that how can i understand .)
I am attaching my simple one record execution plan.
exec-plan-understand.sqlplan
Microsoft SQL ServerSQL
Last Comment
Vitor Montalvão
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
The basics of the Execution Plan or the specific Execution Plan that you posted for your query?
Here are some graphical icons explanations that may help you.
A good help is to pass the cursor over each object in the Execution Plan as it will show more information about what's happening with your query.