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

What is the relation of a user account and a schema?

1111


How to create a new table in your schema?

1069


Explain what are clusters?

1095


How to define a sub function?

1115


What is connection pool in oracle?

972


Explain oracle data types with examples?

1014


How will you write a query to get a 5th rank student from a table student_report?

1847


How to use regular expression in pattern match conditions in oracle?

1021


Difference between oracle's plus (+) notation and ansi join notation?

1083


Explain oracle left join with an example?

990


How to export data with a field delimiter?

1024


How many types of table in Oracle?

1106


How can Oracle users be audited?

1094


How to connect to a local oracle 10g xe server?

979


What to do if dba lost the system password?

1151