Query Performance

[MP]

How do I increase the performance of a SELECT query with GROUP BY clause?

[Bricklen]

MP wrote:

How do I increase the performance of a SELECT query with GROUP BY clause?

That spartan question will not get you many helpful responses.
Oracle version?
Post the query, or an approximation. Have you generated statistics? Have you
looked at the Explain Plan? Any other details that you care to share will likely
help.