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 an UTL_FILE.What are different procedures and functions associated with it?

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

What is the database name in oracle?

What is merge statement used for?

Explain the use of owner option in exp command.

What are temporal data types in oracle?

List the types of joins used in writing subqueries?

Can the query output be sorted by multiple columns in oracle?

Differentiate between pre-select and pre-query?

what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .

i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

For more Oracle General Interview Questions Click Here