>If I'm performing an sql retrieval statement would indexing on the columns in the group by statement speed up the process?
>Here's an example:
>
>Select Sum(Hours_Worked) from tblCustomer
>Group By Department_Name
>Where Last_Name > 'Herman'
>
>Suppose I already had an index on Last_Name. Would adding an index to Department_Name speed things up any?
>
>Thanks,
>
>Valter
No. Grouping occurs on the result set.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer