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 |
What is a field in a table?
How to select nth record from a table?
13 Answers DELL, Microsoft, Ramco,
What do you understand by a view?
Does sql server 2016 have ssms?
Difference between drill down and drill through report.
What is service broker?
What is implicit mode in sql server?
What are recommended options to be used while using db mirroring? : sql server database administration
OPTIMIZATION OF SP,CURSOR,TRIGGERS
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?
What is ddl command?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)