Insert With Indexes Enabled – Import Abandoned After An Hour
Insert With Indexes Disabled – Import and Index Rebuild Finished After 23 Minutes
Insert With Tab Lock and Indexes Disabled – 21 Minutesyou find details about that: Copying Data From One Table To Another – To Disable Indexes or Not To Disable Indexes, That’s the Question.