What would you use to improve performance on an insert statement that places mi

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

Question Posted / narmada kumari

2 Answers
6380 Views
TCS, I also Faced
E-Mail Answers

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 do you understand by fine-grained auditing?