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 the relation of a user account and a schema?
How to create a new table in your schema?
Explain what are clusters?
How to define a sub function?
What is connection pool in oracle?
Explain oracle data types with examples?
How will you write a query to get a 5th rank student from a table student_report?
How to use regular expression in pattern match conditions in oracle?
Difference between oracle's plus (+) notation and ansi join notation?
Explain oracle left join with an example?
How to export data with a field delimiter?
How many types of table in Oracle?
How can Oracle users be audited?
How to connect to a local oracle 10g xe server?
What to do if dba lost the system password?