Benjamin Nevarez

Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning & Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences including the PASS Summit, SQL Server Connections and SQLBits. You can read Benjamin’s blog at or reach him by e-mail at admin at benjaminnevarez dot com and on twitter @BenjaminNevarez.

Follow Benjamin Nevarez via

25 November 2010
25 November 2010

Index Selection and the Query Optimizer

While we all know that the Query Optimizer uses Indexes to produce better execution plans, we don't all know exactly which indexes will give the best results. Benjamin Nevarez has done the research, and in this sample from his upcoming book, "Inside the SQL Server Query Optimizer", he helps us to understand how the Query Optimizer selects indexes to improve execution plans.… Read more