I have a table have about 2,000,000 records in it and I need to update the column SEC_FLAG with 'Y' for all the duplicate values of IP, NAME, DATE_CLICK. I tryed this query, i tryed using collections in pl/sql, but it takes very very long time, any ideas or suggestions?

Thanks.

UPDATE MY_TABLE a SET
a.sec_flag = 'Y'
WHERE a.ROWID >
(SELECT MIN(b.ROWID)
FROM MY_TABLE b
WHERE a.ip = b.ip AND
a.name = b.name AND
a.date_click = b.date_click);