Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 06 May 2004 @ 08:18:09 GMT

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

Subj:   Re: Deleting Duplicates with a single DELETE statement
From:   Victor Sokovin

If you want your table to be always free of duplicates, consider using SET instead of MULTISET option in the table definition. That's a typical feature of TD you probably won't find in Oracle.

SET does add performance overhead with each DML, though, which might be quite visible with larger tables. In that case you might be better off using MULTISET and the query as above scheduled to run after all DML.



  <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: 15 Jun 2023