rivermorrison22 (10/28/2013)
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability