Moving clustered indexes to new filegroup

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

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

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

  • 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