Hi all, I have a Blacklist table containing about 1000 ID to delete from another table (T1 about 1440294 records) If i use the SQL
DELETE FROM T1 WHERE T1.ID IN (SELECT BLACKLIST.ID FROM BLACKLIST) the operation is very slow . There is a faster way to do the same operation?? Thanks Luca ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
