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 is bulk load in oracle?
How can we force the database to use the user specified rollback segment?
Why do we need oracle client?
What are the uses of linked server and explain it in detail?
List out the difference between commit, rollback, and savepoint?
What is ceil and floor in oracle?
How to create id with auto_increment on oracle?
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
what is the difference between functional dependecy and multilevel dependency?
What are oracle functions?
How to bring a tablespace offline?
select trunc(round(156.00,-1),-1) from dual;