We managed a huge
boost in performance by using multiple partitions for our target table.
I agree there are other things that can be done for further improvements. But the one above required almost no effort on our part other than finding out that doing that would improve things.