deleting duplicate records

Mon, 03 Dec 2001 13:27:23 -0800

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

Reply via email to