Archives of the TeradataForum
Message Posted: Wed, 27 Feb 2008 @ 11:16:21 GMT
Subj: | | Re: MLOAD application phase |
|
From: | | Victor Sokovin |
| We have a job that takes 45 min to run using MLOAD. This job has only 400K rows and only inserts (transactions). The target table has 100
MIL rows. Why is it taking such a long time? Is there a way to manage this and reduce time? | |
I think this is a typical question to discuss with your colleagues locally, i.e., within your Teradata working group. If there is no Teradata
knowledge available at the moment the company should hire external consultants.
What's the point of posting such specific questions on the Forum without giving us any details besides the row counts? So that we all start
guessing and overthrowing you with suggestions?
Victor
|