Slow query on 10 millions records of data when applying grouping aggregation

@Chady_Badour, it has been more than a week since I provided some things to think about for your issue. I would appreciate some followup. Even writing that you do not like my ideas and the reasons why is better than leaving the thread to die off.

Thanks