DBA > Job Interview Questions > Microsoft SQL Server FAQs

You are loading 100 rows of data into a narrow t

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries...

You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries. It was recommended that you drop the indexes on the table before the load and then rebuild them after the load is complete. Is this something you would do?

Answer
This does not make sense.
Explanation
For such a small number of rows, it is unlikely that dropping the indexes will improve the performance of your load. If this were 100,000 rows, then it might make sense.

(Continued on next question...)

Other Job Interview Questions