Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 02 Jun 2009 @ 14:12:24 GMT


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


Subj:   Re: MLOAD performance problem
 
From:   Wu Yuren

Two things you need to check, do you have error records in the error table. Usually that is the first place you want to look when you diagnose such issue. If a lot error records being generated, your performance will be abysmal, since error table is taking on record at a time.

If that is not the case, use a Fastload to load the data into a empty table, check what's wrong on the primary index.

NULLs or something like varchar(2k) in your PI will likely cause problem. Mload acquiring phase is actually fastlaod data into a work table with a system defined primary index, your large varchar field with a lot of empty string is likely to cause problem.



     
  <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: 15 Jun 2023