July 22, 2013 at 9:02 am
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
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
I agree. You're need to rebuild the nonclustered indexes on the new filegroup as well.
July 22, 2013 at 10:39 am
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