CODEWITHSUNDEEP
sqlsql-serversql-server-2012
Selçuk Kılınç
Selçuk Kılınç

Reputation: 107

what are sql server index disable advantages?

Most people use "index disable" for bulk import / update operations.

There are 2 approches used. Like these:

1- drop index -> bulk import/update operations -> create index

2- disable index -> bulk import/update operations -> rebuild index

What are the superiorities of second one?

Upvotes: 0

Views: 1548

Answers (1)

zerkms
zerkms

Reputation: 255115

With the second solution you basically don't need to keep the exact DDL for the index, that might be quite complicated.

The only detail you need is an index name to rebuild, which is both easier and less error prone.

References:

Upvotes: 1

Related Questions