T-SQL Optimization: Nonclustered Index and GROUP BY6 Jan, 2015 in Optimization / T-SQL tagged Optimisation / Performance / The Price I Pay by Peter Lalovsky In this example I play with the performance of a query that groups the data.