SQL 2008 Indexes

Question

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 1

Tom.Thomson (2/3/2009)
It seems expensive to me, re-ednabling the clustered index implies rebuilding every index on the table.

With SQL Server 2005 and greater, rebuilding the clustered index does not force a rebuild of all NC indexes.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll