Did you trace the statement? Send a trace to the list.
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Message at the start of svrmgrl
Hello all,
�
could someone please tell me why the procedure below�(Author:Nick Butcher) takes less than a minute�on
a table with 50,000 rows and about 21 mins on a table with 235,000 rows??
�
I�have created a bigger rollback segment to take care of this, but no improvement.
where should i be looking for bottlenecks??
�
CREATE PROCUDURE DUPES_DEL��AS
BEGIN
�
�LOOP
�DELETE from fms_test
�where row_id in(select min(rowid)
���from fms_test
���group by sku_num
���having count (*) >1);
��EXIT WHEN SQL%NOTFOUND
�END LOOP;
��
��COMMIT;
END;
�
appreciate it.
Sunil Nookala
DellCorp.
Austin, TX
