Hello all,
could someone please tell me why the procedure below<SPAN
class=159055620-03122001> (Author:Nick Butcher) takes less than a
minute ona table with 50,000 rows
and about 21 mins on a table with 235,000 rows??<SPAN
class=159055620-03122001>
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 <SPAN
class=159055620-03122001> ASBEGIN
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 NookalaDellCorp.Austin,
TX
Received on Mon Dec 03 2001 - 15:22:49 CST
