Simple query hangs.... Any idea..?

[badrinathn]

Try to use the hint: /*+ USE HASH (a b)*/