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

What is bulk load in oracle?

How can we force the database to use the user specified rollback segment?

Why do we need oracle client?

What are the uses of linked server and explain it in detail?

List out the difference between commit, rollback, and savepoint?

What is ceil and floor in oracle?

How to create id with auto_increment on oracle?

find out the second highest salary?

what is the difference between functional dependecy and multilevel dependency?

What are oracle functions?

How to bring a tablespace offline?

select trunc(round(156.00,-1),-1) from dual;

For more Oracle General Interview Questions Click Here