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 Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023