troubleshooting Question

Insert and Index Overhead

Avatar of tonypatton21
tonypatton21 asked on
Microsoft SQL Server 2005
4 Comments1 Solution395 ViewsLast Modified:
I am working on a file import of 43 million records on a table that is truncated and reloaded with this import each week. There is an index on one of the fields.  If I drop the index and then reload the table , and re-create the index, the process finishes in 10 mins.  If I don't drop the index first and try to insert, the process doesn't finish in an acceptable timeframe. Where is all the extra overhead for the insert when the index is left there? Is this purely a disk bottleneck or more than that?
ASKER CERTIFIED SOLUTION
dqmq

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros