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 |
- Message at the start of svrmgrl Anand Prakash
- RE: Message at the start of svrmgrl Hand, Michael T
- RE: Message at the start of svrmgrl Anand Prakash
- RE: Message at the start of svrmgrl Sunil_Nookala
- RE: Message at the start of svrmgrl Koivu, Lisa
- RE: Message at the start of svrmgrl Nirmal Kumar Muthu Kumaran