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...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

What would you use to improve performance on an insert
statement that places millions of rows into that table?

Question Posted / saraswathi muthuraman

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 are the different types of partitions in oracle?

911

Is a rollback possible to any savepoint?

1001

How to use an explicit cursor without open statements?

1013

How to handle a single quote in oracle sql?

975

Explain about the analyze command in oracle?

998

Explain about achiever in sql?

981

How to use "in" parameter properly?

1006

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2209

What is merge in oracle?

997

What are the uses of linked server and explain it in detail?

1004

What is the difference between substr & instr functions?

1123

What are the extensions used by oracle reports?

998

What is partitioned table in Oracle?

1107

What is execute immediate in oracle?

951

What is the difference between PFILE and SPFILE in Oracle?

996