I have around 7 Million records which needs to be updated. This update
logic is that, if it is the first row of the table the column let's
say c10 will have a value 'I', hence forth the current records value
is will depend on the previous records value, let's say in c7. So
there are few if then elses..
The crux of the matter is that each record needs to be updated on the
previous records value. The entire table is sorted in a specific way.
I have a procedure which works just fine and updates the way it need
to update, but for a small numbers of records only. If the number of
records goes up, lets say 50K it takes for ever, and one can imagine
about updating 7 millions records.
I have tried to use forall and update batch of 1000 records in a
single shot, but still takes days and days which is not acceptable.
Is there a better way to update these many rows, in such a situation??
Thanks in advance..
