Posts Tagged ‘turn off indexes’

26
Mar

Whenever you INSERT data into SQL tables, as each row is added, it also updates the index data on a row by row basis.  So a table with 15 indexes will actually update 16 rows (1 data and 15 index rows) for each insert. Where you are inserting thousands of rows, this can make for MASSIVE log files and LONG processing times. So, to make insertion super fast, always a good idea to DISABLE non-clustered indexes (those indexes which