• 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