What would you use to improve performance on an insert
statement that places millions of rows into that table?
- 1 Answers
- 3019 Views
- I also Faced
- E-Mail Answers
Answer / saraswathi muthuraman
use Bulk collect insert and commit each set of transmission.
| Is This Answer Correct ? | 5 Yes | 0 No |
What WHERE CURRENT OF clause does in a cursor?
What is a proxy class?
What do database buffers contain?
what is kernel?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
what is the difference between no rows returned and null returned?
What is an oracle wallet?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
How to add another datafile to a tablespace?
What are cursor?where are they used?
How to create id with auto_increment on oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
Oracle General 
