So when you re-index, you move the data around. That would make the non-clustered indexes invalid right?
Nope. Nonclustered indexes don't contain the row's physical location when the table is a cluster.
So it must update those indexes, just not rebuild them.
Nope. Not touched in any way.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass