Aggregating 50M of records

[steevej (Steeve Juneau)]

Try some of the things that were share in

Aggregating 50M of records

I forced engine to use the index by using hint but still wasn’t able to optimize the group by. Even the 2nd hack is not working atleast not in my case. But anyways my use case is satisfied by approach 2. Thanks for the ideas, steeve.