Home Forums SQL Server 2008 SQL Server 2008 - General Drop Existing while creating Index RE: Drop Existing while creating Index
er.mayankshukla
SSCarpal Tunnel
Points: 4190
More actions
August 28, 2014 at 7:16 am
#1741635
When I am using Drop_existing = on for NonUnique clustered index , I see no change in nonclusted indexes.
But When I do this for unique CLustered index , I can see Index Insert for Non Clustered index as well
Kindly explain