Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Tue, 04 Jul 2006 @ 18:03:15 GMT





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




Subj:   Re: Multiload to a table and Select denial
 
From:   Pandey, Vivek



Create another copy of the table which is available to the users for reporting when the loading table gets loaded then truncate the old version of the table and so fast insert select into it using the same PI.

By the way did you diagnose why mload is taking 75 mins?


Thanks, Vivek





     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008