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

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

2 Answers  

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

0 Answers  

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  




How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

What is fill factor? : sql server DBA

0 Answers  

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

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

3 Answers  

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

what is the use of recording information about current session?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories