Re: [SQL] DELETE FROM A BLACK LIST

On Wed, 5 Mar 2003 [EMAIL PROTECTED] wrote: > > 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 . > > T

[SQL] DELETE FROM A BLACK LIST

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