Post reply

Dropping Clustered index

  • April 30, 2004 at 2:39 pm

    #160863

    Question:  When you drop and re-create a clustered index, will all related non-clustered indexes be re-created as well?

     

     

  • April 30, 2004 at 2:41 pm

    #504891

    Yes.

    From BOL

    If you drop a clustered index on a table with nonclustered indexes, all the nonclustered indexes are rebuilt to replace the clustered index keys with row pointers.

  • April 30, 2004 at 2:51 pm

    #504893

    I believe that WITH DROP_EXISTING will minimize the nonclustered rebuilds. It's possible if you just drop and then recreate the index for nonclustered ones to be moved more than once.

Viewing 3 posts - 1 through 2 (of 2 total)

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