Big dups Update

[Highlander]

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

[Oracledba8]

This can be resolved by having Indexes on those columns that are appearing in the Where clause.. Even once the Update is done you can drop those indexes.

This will increae the performance for the update.

I have tried and it's very very fast.

Thanks.