Complete Showplan Operators

Comments 13

Share to social media


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

About the author

Fabiano Amorim

See Profile

Fabiano Amorim is a Data Platform MVP since 2011 that loves to conquer complex, challenging problems—especially ones that others aren’t able to solve. He first became interested in technology when his older brother would bring him to his work meetings at the age of 14. With over a decade of experience, Fabiano is well known in the database community for his performance tuning abilities. When he isn’t working, he loves to read and spend time with his family.

Fabiano Amorim's contributions