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 memory advisor in Oracle?

1080


What happens to the current transaction if the session is ended?

1100


What is key preserved table?

1026


Explain temporal data types in oracle

1098


How to use values from other tables in update statements using oracle?

1085


How can we create the complete backup of data in the oracle.

2161


How to create a stored procedure in oracle?

1107


How would you best determine why your MVIEW couldnt FAST REFRESH?

1892


What operating systems are supported by oracle database 10g xe?

1037


Compare and contrast between sql and sql server and explain its various functions?

971


State and explain about oracle instance?

1001


How many data types are supported?

1085


What's dateware house and what's clustor with practicle example

2179


Explain a segment?

1093


Can we commit inside a function in oracle?

968