Re: DELETE performance problem
Maybe this will help some people...
I think I've found a workaround to the problem with the slow DELETEs
It seems that multi-table delete I tried in the earlier post are incredibly slow (around 20 hours) - the same query, when using single table deletes (in series) is orders of magnitude faster. First delete took 10 seconds, second only took 5 mintues - which is a *dramatic* increase in speed.
I know a multi-table delete must be slower (key lookups, merge, etc) - but I had no idea it could be so much slower.
Unfortunately there are still deletes I need to do with multi-table joins, so if anyone has some insight I would greatly appreciate it! :)
Subject
Views
Written By
Posted
3150
January 29, 2005 07:36PM
1846
January 29, 2005 08:30PM
1949
January 30, 2005 04:46PM
Re: DELETE performance problem
2103
January 31, 2005 08:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.