General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Indexing to improve Group by statements
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only