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 >> DB Administration
  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 / narmada kumari

Answers were Sorted based on User's Feedback



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

Answer / setaceo

1. DML Triggers to be DISABLED and then ENABLED once the
insert completed.
2. DISABLE the Clustered Index and then ENABLED once the
insert completed.
3. After completion of INSERT, Defragmentation should be
there.
4. After completion of INSERT, Statistics should be updated.
5. (Optional) If it is non-peek time & This is the only
activity is going on then, Database recovery mode should be
SIMPLE / BULK-LOGGED. ( It should not be there along with
other activities....)

Is This Answer Correct ?    4 Yes 0 No

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

Answer / braj123

Check that any indexes are there.
Drp the indexes and recreate after insert.

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More DB Administration Interview Questions

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

What would you do with an "in-doubt" distributed transaction?

0 Answers  

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

For more DB Administration Interview Questions Click Here
Categories