Clark,
Have you tried using a hint to use PARALLEL SQL servers (if available)? Also, is your SQL optimized so that the most distinctive criteria are listed last in your WHERE clause? I just recently learned that (at least) in Oracle, the conditions (WHERE clause) is processed "backwards." I would think that more tables would mean more processing time.
HTH,
Chuck