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

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

1 Answers  

what is the difference between catalog & nocatalog?

3 Answers   CSC,

Explain about your sql server dba experience? : sql server DBA

0 Answers  

one datafile is lost in standy side how can you recover that??

2 Answers  

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

what is asm?

0 Answers   Oracle,

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

0 Answers  

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  

What view would you use to look at the size of a data file?

3 Answers  

what is meant by gateway

1 Answers   IBM,

For more DB Administration Interview Questions Click Here
Categories