2

I have a large table that I am updating. Is it possible to disable index updates on the destination table until the load is complete? It seems like a waste for it to be constantly updating the index with each commit.

I can just drop and recreate the index before and after the load, I just want to know if there is a quick way to configure that in the OLEDB or SQL Server destination.

Server is Windows Server 2003 Datacenter Edition, running SQL Server 2008 Standard Edition with SSIS.

Mattew
  • 163
  • 1
  • 5

1 Answers1

0

ALTER INDEX IndexName ON Table DISABLE

I'm not sure that doing this will help you though - the index needs to be updated sooner or later. Perhaps you would disable auto stats update until the full load is done.

Sam
  • 2,020
  • 1
  • 16
  • 22