Originally posted by tamilselvan
Slimdave,
It is not the group by clause causing the problem b/c the result set after joining 2 big tables is small. MERGE JOIN operation is causing real problem of filling out the temp space. I am trying to eliminate MERGE JOIN by adding an INDEX.

Tamil
OK I see ... well I'd think that a hash join would be worth trying also.

srt, do you have hash joins enabled in your db?