What would you use to improve performance on an insert
statement that places millions of rows into that table?
- 1 Answers
- 3041 Views
- I also Faced
- E-Mail Answers
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
How to fetch the row which has the max value for a column?
What happens if you set the sga too low in oracle?
What is merge in oracle?
State and explain about oracle instance?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How to define a data field as not null?
Difference between inner join vs where ?
How to rename an existing table?
What is a cursor in oracle?
How to start a specific oracle instance?
What is a user account in oracle?
How to view the data files in the current database?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What suggestions do you have to reduce the network traffic?
What is a initialization parameter file in oracle?
