Thank you! Every one for your time and response.
Yes you are right two days is too much and it was executed by testing team in test region and they kept on waiting. Since changed by me I was asked to analyze.
I rexecuted the same job in development region and again it went too quick. As suggested by GUY C suspecting the performance and went to DBA. It was index problem. they have fixed it. Hopefully it should work now.
Yes, this is how I deal with DBA's ..
. I tell them the problem I am facing with the statistics and let them play. If something is really there they come back with a fix otherwise they tell us to check the changes.
Thanks ! Again.