What would you use to improve performance on an insert statement that places mi

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?

Question Posted / venkateswararao

1 Answers
3646 Views
I also Faced
E-Mail Answers

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

Answer / saraswathi muthuraman

use Bulk collect insert and commit each set of transmission.

Is This Answer Correct ?

5 Yes

0 No

Post New Answer

More Oracle General Interview Questions

Explain table?

primary key is foreign key for the same table?

2 Answers Oracle,

What is tns name?

What are advantages fo Stored Procedures?

How to create a table index in oracle?

How to call a stored procedure inside a trigger? Give an example.

1 Answers Exilant,

12 RULES OF RDBMS

Explain the use of compress option in exp command.

What is dual table oracle?

What is an oracle user role?

What is a partition in oracle?

How to create a new tablespace in oracle?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)