Originally posted by badrinathn
Try to use the hint: /*+ USE HASH (a b)*/
er, dont you see it's already doing hash join....? it is USE_HASH anyways