How to increase performance of bulk update
518838May 16 2007 — edited May 17 2007I'm running a pl/sql stored procedure which update bulk data ranging from 10 to 1 million rows in a single update statement.
As obvious, too much will be the rows, too much time it will take to update.
As the query I'm using to update the rows is using the index range scan, it should update the rows much faster, but its taking a lot of time causing my application to go down for hours.
Is there any way to find out the reasons why my bulk update takes too much time?
Thanks
Deepak