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?

  • March 7, 2014 at 6:01 am

    #1695083

    Which DML operation?

    If you're talking about updates/inserts/deletes, that's because the indexes themselves also need updating.

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