Hi all,

I have to update a table with around 2 million records in it.
Also for each record I need to update some child tables for which I am using
UPDATE statements.

Can anybody give me any statistics about how performance improves if bulk
collect and FORALL is used in place of normal UPDATE statements.
Also How much records, I should take in a single bulk collect e.g. 100,
1000, 10,000, or 100,000.

Any help will be highly appreciated.

Thanx,
Prashant




Oracle LazyDBA home page