Hello all,
could someone please tell me why the procedure
below(Author:Nick Butcher) takes less than a min<SPAN
class=175265920-03122001>ute ona 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 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:27:23 CST
