Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Why the Indexes on table slow down the DML operation on table, what is the exact reason? RE: Why the Indexes on table slow down the DML operation on table, what is the exact reason?

  • Tony1234 (3/7/2014)


    Thank you for quick response,

    It can be update\Insert.

    There are cases where an index might speed up an update statement, as the index allows to easier find the to-be updated rows, but generally speaking updates and inserts are slowed down by indexes because the index needs to be maintained to reflect the changes.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP