How to optimize a group by query

[Abhishek]

Hi all,

I have written a query with group by clause, it is consuming lot of time is 
there any way to optimize this any configuration property or some thing.

Regards 
Abhi


Sent from my iPhone