Archives of the TeradataForum
Message Posted: Tue, 25 Dec 2012 @ 10:17:56 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|