plreeter (1/13/2009)
Does anyone know if disabling the indexes and rebuilding them after the bulk insert is a more efficient method than dropping the indexes and recreating them after the insert?
It'll be the same. The index b-tree still needs to be built in both cases. The only difference between disabled and dropped is that disabled doesn't remove the metadata
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability