Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How to start a new transaction in oracle?

1088


What is the difference between alert log file and tarce file ?

2172


How to estimate disk space needed for an export job?

1050


What is a relational database management system?

1120


What is data block in Oracle?

1116


How to write numeric literals in oracle?

1183


What is bulk load in oracle?

1070


what is IDE,DMV in sql server?

2819


What is a table index?

1098


What exactly do quotation marks around the table name do?

963


How to connect asp pages to oracle servers?

1072


what is a Nested Loop join?

2113


How many types of database triggers exist?

1135


Explain enable novalidate constraint.

1081


How do we display rows from the table without duplicates?

972