Post reply

Moving clustered indexes to new filegroup

  • July 22, 2013 at 9:02 am

    #280352

    I am rebuilding the clustered index of a table to a new filegroup using DROP EXISTING in order to move the data to the new filegroup.

    Does this rebuild the non-clustered indexes of that table on the new filegroup as well?

    Thanks!

  • July 22, 2013 at 9:14 am

    #1634513

    No! Non-clustered indexes will use only the clustered index keys. Unless otherwise explicitly you created the non-clustered index on the new filegroup, it won't be created there. Non-clustered indexes will have a logical connection only with the clustered keys.

  • July 22, 2013 at 9:26 am

    #1634523

    I agree. You're need to rebuild the nonclustered indexes on the new filegroup as well.

  • July 22, 2013 at 10:39 am

    #1634574

    Thanks for clearing that up!

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

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