Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 16 Jul 2012 @ 18:48:02 GMT


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


Subj:   Re: Insert into table with same select is too slow
 
From:   Dave Wellman

Hi,

Firstly, is your processing blocked? Use Viewpoint or Pmon or 'whatever' to find out.

Secondly, what volume of rows are you talking about?

Also consider if the target table is already populated. If it is then each inserted row will be written to the Transient Journal. This will slow down the processing.

If this is the case then can you merge both tables into one new one ? I've seen that run a lot quicker than what you are currently trying to do. But, again, you have to consider volume. If you are trying to add 250 rows a 250 million row table, then just do it (but it shouldn't take 4 hours). If you are trying to 250 million rows to 250 rows, then reverse the logic (if you can). If you are trying ot combine two 250 million row tables, then probably try merging them into a third, empty table - use two insert/selects coded as an MSR.


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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: 23 Jun 2019