What's that Garbage in My Execution Plan? (Dear SQL DBA Episode 27)
Vložit
- čas přidán 25. 01. 2017
- Learn how to approach the unexpected in a mysterious execution plan that contains way more operators than expected for a very simple SQL Server query.
Prefer a written version of the story? Read the show notes at www.littlekendra.com/2017/01/... - Věda a technologie
This was absolutely in no way even close to what I was looking for when I did my search on youtube, but I'm glad I found it because this is pretty interesting and I'm glad I learned about it before I ever got confused by it :D
Awesome job! In-addition to the overall execution plan explanation/insight... I really loved the perspective on how even for a well seasoned individual can also have moments of doubt or sense of SQL/plan confusion etc. And you were real with it!
Very nice! Taught me something else Kendra! I love your videos; thanks for sharing!!
Thanks very much for this, especially the last couple of minutes have made me want to persevere with learning more about execution plans.
I have been spinning my wheels with learning query plan analysis the past couple of weeks during lock down and its great to see something that says "stick with it!" instead of "I'm an expert - stand back and be amazed..." from a tutorial...
That was extremely insightful, thank you.
Holy cow! That's an execution plan if I've ever seen it. I'm an application developer by trade but I'm diving into low-level SQL stuff, so I'm trying to learn about execution plans and how to optimize. Very helpful!
So helpful! I'm new to execution plans and this totally helped me find out why a script was taking so long. Thank you Kendra! Awesome last name btw :)
Thanx, GREAT video! As usual....
I hate computers.
Nice 💯
too much un nessary talks
For one line she wasted my 17 min. Shit these types of videos
I will refund your money promptly
Not only was the video not a waste, it was *extremely* helpful to here Kendra's breakdown on how to approach an execution plan review, not to mention the positive affirmation of don't give up on the plan, keep going, etc. It's a shame you took so little away from this.