Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 02 Mar 2004 @ 10:30:14 GMT


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


Subj:   Re: Delete Query on a huge table taking too much time
 
From:   Mirjam Berger

Hi,

there is a third method for increasing the speed of your deletes... I bring that up because not everybody has the right to just replace the existing production table with a new table. I would guess most of us don't have those rights. And Mload might introduce other bottlenecks into your process.

You could create an interim table that only holds the data you need to delete. (Insert select into an empty table tends to be very quick).

The interim table should have the same structure, as the real production table that you want to delete from. But it's enough if your interim table carries all columns that you need to identify a row that is to be deleted.

You can than delete from your production table by joining on the interim table. This should guarantee PI access over full table scan, thus speeding things up :)


Hope this helps!

Mirjam



     
  <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: 27 Dec 2016