April 30, 2004 at 2:39 pm
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
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
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply