Does rebuilding a clustered index rebuild nonclustered indexes?

Clustered Index Rebuilds Affecting Non-Clustered Indexes

Technical Weblog of Eric Charran — Wed, 28 Feb 2007 00:44:46 GMT

Another nifty note about indexing. One of the more popular interview questions for technical folks is

re: Does rebuilding a clustered index rebuild nonclustered indexes?

colin leversuch-roberts — Wed, 28 Feb 2007 11:48:21 GMT

actually this is a great step forward for index rebuilding, there are times when this is exactly what is required. Thanks, I hadn't explored this option.

Does rebuilding a clustered index rebuild nonclustered indexes?

SQL Server Performance and Tuning - (SSQA) — Mon, 25 Jun 2007 23:48:05 GMT

Does rebuilding a clustered index rebuild nonclustered indexes? I have discussed this question with one

re: Does rebuilding a clustered index rebuild nonclustered indexes?

abhay_ch — Sat, 15 Sep 2007 02:20:56 GMT

I have few Questions Ken...

1) I have checked in SQL Server 2005 That If we rebuild the Clustered Index , it does not rebuild the Non-clusered indexes.

Database :Adventureworks

Table : Production.Product

2) secondly , even if i rebuild the indexes , there is no change in the fragmentation ..

3) in the same database i have seen that if rebuild the indexes ....fragmentation increases ..

Pretty confused .........