Complete Showplan Operators

Fabiano Amorim has taken the time to reallv drill into the behavior of a small set of execution plan operators in an effort to explain the optimizer's behavior. He's explored why things happen, how you can change them, positively or negatively, and he's done it all in an approachable style.

1380-FabianoCover.jpg

Complete Showplan Operators

Fabiano Amorim

Writing good TSQL code is not an easy task. Then you submit the code to the query optimizer and strange things happen. The one good view you have into what the optimizer decided to do is provided by the execution plans. Understanding execution plans is a lot of work. Trust me on that. What you need to really understand your queries is as much knowledge as you can get. That’s where this excellent collection of articles on some of the more common execution plan operators comes in.

Fabiano Amorim has taken the time to reallv drill into the behavior of a small set of execution plan operators in an effort to explain the optimizer’s behavior. He’s explored why things happen, how you can change them, positively or negatively, and he’s done it all in an approachable style. You want information and knowledge in order to achieve understanding.

When I wrote my book on execution plans, 1 really did try to focus on the plan as a whole So while I spent time talking about individual operators, what they did, and why they did it, 1 was frequently not as interested in discussing everything that an individual operator might do once I had established their role in a given plan. Having someone like Fabiano come along and go the opposite route, sort of ignoring the whole plan in an effort to spend time exploring the operator, acts to fill in gaps. Where I tried to teach how to read an execution plan, Fabiano is trying to teach what a given operator does. It’s all worth- while and it all accumulates to give you more knowledge.

Reviewed by Grant Fritchey

Tags: , , ,

  • 21866 views

  • Rate
    [Total: 35    Average: 4.4/5]
  • ElSuket

    Broken links
    Hi Fabiano,

    I’m much interested in this e-book, but can’t download both of them (can’t establish a connection to them).

    Is is possible to get either of them ?

    Thanks for that and for your deep insights given freely to the SQL Server community.

    Regards, Nicolas Souquet.

  • mcflyamorim

    .
    Hi ElSuket, I’m glad you are interested in the e-book, not sure why you can’t download the files, maybe it’s because it is under a http://ftp...
    Anyway, I just uploaded the pdf file into my blog and you can downlaod it here: http://mcflyamorim.files.wordpress.com/2011/12/complete_showplan_operators_fabiano_amorim-without-video.pdf

    Cheers

  • Andrew Clarke

    Problems downloading
    Someone accidentally forgot to start the FTP service after a restart. All sorted now.

  • ElSuket

    Broken links
    Cheers guys !

  • msrviking

    Problems downloading even today!
    Well same issue in downloading. Never kicked off, but used the alternate address.

    Thanks for writing such a nice stuff.

  • ramih

    Problems downloading
    Problems downloading

  • breathe

    Downloading…not!
    Hi…

    I’m unable to download what looks to be an awesome book.

  • breathe

    But the one from the blog link works!
    thanks!

  • asun_bigholy

    Problem with Getting the samples ppt and codes
    Hi,
    I got "Material, Seminário Execution Plan.zip" from your SkyDrive, but could not extract it, could you tell me the password?

  • alhandra

    epub
    Hi the epub is not available on the link, can you please check?

  • Stephen Howe

    Incomplete ShowPlan operators
    I have downloaded the PDF guide for Complete Showplan Operators and I find it incomplete.

    Where are Nested Loops?
    Where are Hash Aggregates and Hash Joins?

  • Stephen Howe

    Incomplete ShowPlan operators
    I have downloaded the PDF guide for Complete Showplan Operators and I find it incomplete.

    Where are Nested Loops?
    Where are Hash Aggregates and Hash Joins?

  • SQLWayne

    epub is still a 404
    And that makes me a sad panda. 😉

  • Thales Bezerra

    Problems downloading