Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 21 Jun 2013 @ 10:14:39 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Fastest Way to Delete data from Table
From:   Ghodke, Pradnya

Hi All,

I want to delete those records from Table1 which are present in Table2.

Using below query.

     DELETE FROM Table1
       WHERE     (key1, key2)  IN
           SELECT UNIQUE key1, key2 FROM Table2

Could any suggest any other fastest alternate way to do so.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020