|
Comments
|
|
Phenomenal video. Thank you.
|
|
|
This was concise information regarding a feature of SQL Server that I have not previously used. Now that I know about this feature, and how easy it is to use it, I will be able to use.
|
|
|
should have included what to look for in an execution plan to do the actual fine tuning
|
|
|
basic
|
|
|
Q)Why are execution plans read from right to left instead of left to right?
|
|
|
But how do I use it?
|
|
|
What about turning on the actual execution plan permanently (rather than remembering each time)?
|
|
|
keep it coming.
|
|
|
Straightforward, and important info.
|
|
|
Why do you always read an execution plan from top to bottom and from right to left? It would have been good information for someone just learning about execution plans to know why it's read this way.
|
|
|
Good
|
|
|
I don't have a clue why MS set it up to read right to left. It just is. I'm sure they had a reason, but I don't recall ever seeing it in any documentation. Looking at it, it kind of makes sense when you think that the the thing immediately in front of you, the SELECT operator or whatever, is the culmination, the result, of all the other work and you then just have to track out on the tree to see what was done... But I could be wrong on that one.
|
|
|
I love this short video, they are execellent for newbiew like me.
|
|
|
Palani Ramu on 09/13/2009
It's very useful for beginers and its explanation also good.
|
|
|
I learned one thing, browsing the execution plan... What would be good is to understand an execution plan.
|
|
|
essential knowledge for SQL developers
|
|
|
nice job
|
|
|
Although I have looked at execution plans before, I didn't know that they should be read from right to left or how you could move around in the plan. Thanks very helpful
|
|
|
Such a "simple" thing, but as an "occasional developer" I've never delved into query plans, although I often see them mentioned on the boards. Now I'll have to go try it! This really demonstrates the value of these short videos; I truly appreciate the folks who put these together.
|
|
|
http://tinyurl.com/Grant-Fitchey-book
|
|
David Hunter on
5/12/2010
Good introduction \ overview to the Graphical Query Plan tool.
|
|
|
Cool!!!!!!!!!!!!!
|
|
|
didn't tell me much
|
|
|
this is very useful in optimizing the queries
|
|
|
Good but it should be pointed out that execution plans are best used when comparing queries against each other. A plan by itself provides little information, you have to compare it to something. Hashs and scans may be the only way information can be retrieved, but comparing two or more query plans can provide insight as to which design is better over all.
|
|
|
excellent video
|
|
|
good
|
|
|
Nice tips on scanning an execution plan. Important topic.
|
|
|
clear
|
|
|
brilliant, all covered in a couple of minute!
|
|
|
Good
|
|
|
Glad so many people found it helpful the second time through. These short videos were an experiment that didn't entirely work well. But this seems to be one exception.
|
|
|
like the way you explained the basics i.e. simple and to the point
|
|
|
Thank you.
|
|
|
good one
|
|
|
Have never used a graphical execution plan but I can see how they will be useful. Not sure why there would be a difference between an estimated and an actual execution plan though unless it's down to the figures and cost involved.
|
|
|
The main key difference between estimated & actual is the inclusion of real stats on the actual plan. The estimated plan is just a guess, the actual has real numbers. Plus, plans can recompile during execution and when that happens, they can, and do, change. So getting the actual plan shows you, as close as you can get, what really happened when the query executed.
|
|
vin lawrence on
1/20/2012
does what it says on the tin
|
|
|
Good, but short - actual vs estimated execution plan - would like to see more detail on the difference, and how to fix or optimize if estimated does not = actual?
|
|
|
Good intro - need to segue to another for completeness.
|
|
|
So much I didn't know and I have often looked at estimated query plans. Thanks!
|
|
Tom Stafford on
1/20/2012
Video did not explain why you read from right to left and what that means.
|
|
|
Thank you
|
|
|
Would like to see more detail about this topic. What each of the objects mean and how they pertain to optimizing a query. That would be wonderbar!
|
|
|
Very concise!
|
|
|
Great for a JR DBA. I think it would have been beneficial to quickly discuss the advantages and disadvantages between actual and estimated execution plans.
|
|
Kasey Wheeler on
1/20/2012
Good video.
|
|
|
Basic intro to looking at the execution plan
|
|
|
ok that's great we now know how to look at this, but how to we USE this information?
|
|
|
Quite well presented but no explanation of how to optimise the query after looking at the execution plan and what the various information about each icon or arrow means.
|
|
|
Excellent, lots of info in very little time. How about something on how to spot (with execution plan) and fix some of the most common simple mistakes us rookies make.
|
|
|
very good and informative.
|
|
|
Very clear and informative
|
|
|
ALWAYS looking for quick and easy to follow info on execution plans!
|
|
|
This will help me. Thanks for sharing.
|
|
|
Not very infotmative
|
|
|
didn't really say "why", which I thought was "advertised"
|
|
|
I don't have access to do this on the server I use.
|
|
|
excellent reminder
|
|
|
Well-explained, good job
|
|
|
too simply
|