er.mayankshukla (8/25/2014)
What if I Only fire a drop Clustered Index command and NO Create command ?
Then every single nonclustered index on the table will be rebuilt, they have to be because the 'pointer' to the row changes from the clustered index key to a RID
Drop_existing isn't a persisted setting, it's not remembered. It applies to a specific create index statement only and has no lingering effect after the create completes.
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