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

Answer Posted / saraswathi muthuraman

use Bulk collect insert and commit each set of transmission.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is object data modeling?

583


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1937


What is instant client oracle?

621


What is MTTR advisor in Oracle?

694


How to create a server parameter file?

656






What is a Garbage Collection? and what is full recursive Garbage collection?

2476


How to check database size in Oracle?

728


Explain an index?

752


How to install oracle database 10g xe?

645


What is a select query statement in oracle?

618


What is a subquery?

701


Briefly explain what is literal? Give an example where it can be used?

642


What is oracle used for?

627


How to retrieve data from an cursor to a record?

637


What is a procedure in oracle?

691