Re: delete duplecated rows

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: Thu, 15 Mar 2001 01:45:54 -0800
Message-ID: <3AB08F52.B9E96DE7@ntsource.com>

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