Thread: DELETE FROM A BLACK LIST

DELETE FROM A BLACK LIST

From
luca.scaramella@recom.it
Date:
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