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... 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... 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... 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... 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... 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... 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... 14 October 2009 10 min read
