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