Disabling Indexes - SQL School Video

  • Comments posted to this topic are about the item Disabling Indexes - SQL School Video

  • 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!!

  • 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!

  • 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

  • Great Video...:)

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply