Fabiano Amorim ShowPlan Operator of the Week – Merge Join Did you ever wonder how and why your indexes affect the performance of joins? Once you've read Fabiano's unforgettable explanation, you'll learn to love the... 22 November 2010 9 min read
Fabiano Amorim Showplan Operator of the Week – SORT Fabiano introduces another ShowPlan operator that is used to build a query plan, or perform an operation specified in the DML. Once again, Fabiano demonstrates... 11 October 2010 5 min read
Fabiano Amorim Showplan Operator of the Week – Row Count Spool The Row Count Spool operator is a simple component in an execution plan that can make an enormous difference to SQL query plans that would... 06 July 2010 5 min read
Fabiano Amorim Operator of the Week – Spools, Eager Spool For the fifth part of Fabiano's mission to describe the major Showplan Operators used by SQL Server's Query Optimiser, he introduces the spool operators and... 20 May 2010 12 min read
Fabiano Amorim Showplan Operator of the Week – BookMark/Key Lookup Fabiano continues in his mission to describe the major Showplan Operators used by SQL Server's Query Optimiser. This week he meets a star, the Key... 07 May 2010 7 min read
Fabiano Amorim Showplan Operator of the Week – Compute Scalar The third part of Fabiano's mission to describe the major Showplan Operators used by SQL Server's Query Optimiser continues with the 'Compute Scalar' operator. Fabiano... 28 April 2010 6 min read
