Freigeben über


Clustered Index Rebuilds Affecting Non-Clustered Indexes

Another nifty note about indexing.  One of the more popular interview questions for technical folks is the various effects a change to a clustered index can have on nonclustered indexes.  This post clears some of that up:

Does rebuilding a clustered index rebuild nonclustered indexes

The answer may surprise you.  Essentially, altering a clustered index does not affect the nonclustered indexes.  Dropping and recreating do.