November 25, 2008 at 10:03 pm
Comments posted to this topic are about the item Disabling Indexes - SQL School Video
January 13, 2009 at 1:01 pm
EXCELLENT video presentation! The speed of the presenter, both in speech, and in demonstration was tremendous! Especially the parts where he would give simple reminders, of what he's covered, to keep everyone up to speed. Good job!!
January 13, 2009 at 3:23 pm
Great video!
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?
I'm loading several million rows and with the drop/create method it takes up to 5 hours to recreate the indexes.
Thank you!
January 13, 2009 at 3:42 pm
I don't think there would be much difference, as behind the scenes you essentially have a lock, logged page deallocation, and index build + logging in both cases.
Best way is to try it and see. At the very least you'll be happy to lose all that DDL code you've been using in your existing process. 😀
~BOT
Craig Outcalt
January 14, 2009 at 8:47 am
Great Video...:)
January 14, 2009 at 9:00 am
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply