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
What is memory advisor in Oracle?
What happens to the current transaction if the session is ended?
What is key preserved table?
Explain temporal data types in oracle
How to use values from other tables in update statements using oracle?
How can we create the complete backup of data in the oracle.
How to create a stored procedure in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What operating systems are supported by oracle database 10g xe?
Compare and contrast between sql and sql server and explain its various functions?
State and explain about oracle instance?
How many data types are supported?
What's dateware house and what's clustor with practicle example
Explain a segment?
Can we commit inside a function in oracle?