Everything I have read and heard indicates that you should index any field that you do a 'where' or 'order by' on. Is this also true for 'group by's or does it not matter?
Index on Group By Variables
Index on Group By Variables
FYI - I added the GROUP BY field to my compound index, and it increased the speed of my search by over %500.