Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: delete duplecated rows
If you do not have an index on col_name, it might help to first create and analyze an index for the column, col_name, and then do the deletion.
Frank Hubeny
u132781982_at_spawnkill.ip-mobilphone.net wrote:
> Hi, I have quite some duplecated rows to delete.
> I tried somebody's suggestion
>
> delete from TABLE_NAME a
> where a.rowid != (select max(row_id)
> from TABLE_NAME b
> where b.col_name = a.col_name)
>
> but it takes so long, finally I have to kill it.
>
> Any better suggestions?
>
> Thanks
>
>
>
> --
> Sent by dbadba62 from hotmail part of com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Thu Mar 15 2001 - 03:45:54 CST
![]() |
![]() |