Don't know where my last post went so I apologise if this is posted twice.

I've attached a set of INSERTS for the jobtran table representing some doctored data. I hope this is sufficient for analysing the performance. Let me know if you need more.