Fabiano Amorim Join Reordering and Bushy Plans Normally, the query Optimiser won't consider 'bushy' plans, where both operands to a join operator could be intermediate results from other joins. This means that... 05 March 2013 17 min read
Grant Fritchey Statistics in SQL Server SQL Server's Query Optimiser relies on statistics for providing a decent query plan. If the statistics are wrong, outdated or missing then you have little... 08 January 2013 10 min read
Joe Sack Fixing Gatekeeper Row Cardinality Estimate Issues The Query Optimiser needs a good estimate of the number of rows likely to be returned by each physical operator in order to select the... 01 November 2012 18 min read
Benjamin Nevarez The SQL Server Query Optimizer To understand how to write SQL code for SQL Server that performs well, it is important to appreciate how the query optimizer works. Ben Nevarez... 03 August 2011 35 min read
Fabiano Amorim 13 Things You Should Know About Statistics and the Query Optimizer Fabiano launches into a sound technical explanation of the way that the query optimiser works in SQL Server with a mention of Brazilian Soccer stars... 07 January 2010 24 min read
Fabiano Amorim Query Optimizer and Cartesian Products In his continuing quest to bring a deeper understanding of Query Optimizer to the world at large, Fabiano takes a moment to point out a... 22 October 2009 5 min read
Fabiano Amorim Data Correlation Optimization Internals Having adroitly introduced us, in his previous article, to the Date Correlation ability of the Query Optimizer, Fabiano discusses the inner workings of this little-known... 14 October 2009 10 min read
