Originally posted by marist89
I would look at reducing your LIOs.
Those LIO's are probably the result of the hash join ... v. LIO-intensive, hash joins.