Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 01 Mar 2004 @ 10:16:37 GMT


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


Subj:   Re: Delete Query on a huge table taking too much time
 
From:   Frank O Connor

Rishi

Following on from Ulrich's comments, I would recommend that you use Multiload Delete.

You should consider the following:

Dropping the secondary indices. They are not used by mload and every block is affected. Also, SI's will cause a large work table to be created and the index application phase can be quite slow. So, it is better to drop the index and recreate after the rows have been deleted.


Also, remember, that the mload must complete. Therefore, you may need to consider archiving it before you commence the MLOAD.


Good luck

Frank



     
  <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