indexes on aggregate columns Archives

SQL Server: Indexing for Aggregates in SQL Server

August 9, 2011September 30, 2014 - by Amit Bansal - 10 Comments.

Hi Friends, Here is a query and I want to create the right indexes for it. Let us do things step by step: (I am using AdventureWorks2008 for this) SELECT SOH.CustomerID, …