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 rebuild index??

2 Answers   IBM, Sapient,

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,

What authentication modes does sql server support? : sql server DBA

0 Answers  

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

How many packages we have in db

1 Answers   Tesco,

What is fill factor? : sql server DBA

0 Answers  

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

how can you connect from 10g user to 11g user??

0 Answers   HP,

Why would you call update statistics? : sql server DBA

0 Answers  

What does coalescing a tablespace do?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories