Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 27 Feb 2008 @ 11:16:21 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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?


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020