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);