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


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


  <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