Does index slows down insert statements?



Does index slows down insert statements?..

Answer / Ramesh Chandra Chaudhary

Yes, creating an index can slow down insert statements because the database has to update the index as well as the table during the insert operation.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is a field in a table?

1 Answers  


How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,


What do you understand by a view?

1 Answers  


Does sql server 2016 have ssms?

1 Answers  


Difference between drill down and drill through report.

1 Answers  


What is service broker?

1 Answers  


What is implicit mode in sql server?

1 Answers  


What are recommended options to be used while using db mirroring? : sql server database administration

1 Answers  


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1 Answers  


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

5 Answers   Aptech, HCL, Perpetual, SAIC,


How to use clusters?

1 Answers   Amdocs,


What is ddl command?

1 Answers  


Categories