What would you use to improve performance on an insert statement that places mi

What would you use to improve performance on an insert
statement that places millions of rows into that table?

Question Posted / venkateswararao

What would you use to improve performance on an insert statement that places millions of rows into ..

Answer / saraswathi muthuraman

use Bulk collect insert and commit each set of transmission.

Is This Answer Correct ?

5 Yes

0 No

More Oracle General Interview Questions

How to find the date and time of last updated table?

What is a Shared SQL pool ?

what is the bitmap index?

What is self-referential integrity constraint ?

Explain the use of constraints option in exp command.

What is a trace file and how is it created in oracle?

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

What are transaction isolation levels supported by oracle?

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

how will I find the first 5 highest salaried employees in each dept in oracle.

What happens if you use a wrong connect identifier?

What are various joins used while writing SUBQUERIES?

For more Oracle General Interview Questions Click Here