What would you use to improve performance on an insert
statement that places millions of rows into that table?
Answer / saraswathi muthuraman
use Bulk collect insert and commit each set of transmission.
| Is This Answer Correct ? | 5 Yes | 0 No |
What are ddl statements in oracle?
What happens to the indexes if a table is recovered?
What is ADDM Advisor in Oracle?
what happened to the global index when I truncate the data in one of the partition?
What suggestions do you have to reduce the network traffic?
What is literal?
how to retrieve 1st and last row of table without using group functions??
what are pseudocolumns?
How to commit the current transaction in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
Explain alias?
What is logical backup in oracle?