You can try all sorts of different tweaks, but until you trace the process you don't have a clue as to what is taking the most time. With the +APPEND hint maybe you are taking a query that takes 3 minutes down to 2.5 minutes. Is it really worth it? Trace it.