Archives of the TeradataForum

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

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

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.

Thanks,

Dipti Prakash

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