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.
1 Like