Hi all,

Oracle balances the B*-tree indexes after each INSERT statement or after each row is added to the table. Let say, if I have to add 1000 records to a table. If I generate 1000 INSERTs of 1 row Oracle will balance the tree after each insert. But If I have 1 INSERT (statement) of 1000 records does Oracle balance the tree once or 1000. I know that it will be 1000 parse time and execution instead of 1 parse time and execution. What's about indexes.


Thanks in advance