DELETE FROM A BLACK LIST

Поиск
Список
Период
Сортировка
От luca.scaramella@recom.it
Тема DELETE FROM A BLACK LIST
Дата
Msg-id OFC425EC90.A6DA753C-ONC1256CE0.003861F2@recom.it
обсуждение исходный текст
Ответы Re: DELETE FROM A BLACK LIST  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: DELETE FROM A BLACK LIST  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-sql
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






В списке pgsql-sql по дате отправления:

Предыдущее
От: luca.scaramella@recom.it
Дата:
Сообщение: DELETE FROM A BLACK LIST
Следующее
От: "Chad Thompson"
Дата:
Сообщение: Re: filtering out doubles