Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 25 Dec 2012 @ 10:17:56 GMT

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

Subj:   Re: Deleting rows from a table which EXIST in another table
From:   Lenka, Dipti Prakash

Have you tried this ?

     delete from large_table
     WHERE (Col1,Col2)
     IN (SELECT Col1,Col2 from exceptions_table GROUP BY 1,2);

The above query may take hours to delete the data if the table is having 100GB or above data.

To deal with GB or TB data deletion, you can use MULTILOAD DELETE mode option.

2cents from my side.


Dipti Prakash

  <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: 28 Jun 2020