Closed. This question needs debugging details . It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem . This will help others answer the question.

Closed 18 hours ago.
Improve this question

I have a query which is running on a 50GB table and doing a lot of aggregations with group by and taking 30 minutes to run, what are my options to optimize it?, please suggest.

I tried putting indexes and updating stats but nothing helps, need to find out what could be an alternative to a group by.