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
How to start a new transaction in oracle?
What is the difference between alert log file and tarce file ?
How to estimate disk space needed for an export job?
What is a relational database management system?
What is data block in Oracle?
How to write numeric literals in oracle?
What is bulk load in oracle?
what is IDE,DMV in sql server?
What is a table index?
What exactly do quotation marks around the table name do?
How to connect asp pages to oracle servers?
what is a Nested Loop join?
How many types of database triggers exist?
Explain enable novalidate constraint.
How do we display rows from the table without duplicates?