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
