Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gail Shaw Introduction to Indexes: Part 3 – The nonclustered index RE: Introduction to Indexes: Part 3 – The nonclustered index

  • July 20, 2012 at 9:09 am

    #1515590

    IgorMi (7/20/2012)

    Hi Gail

    I want to thank you for your effort on indexes.

    I'll use this opportunity to ask a question.

    Example: There is a Table with one clustered index and some non-clustered. It is connected to more other tables.

    Then I create non-clustered index(es) on the table, in order to execute some queries faster, and then i want to drop the non-clustered index(es), because some other actions to that table may change.

    Is it a reasonable practice?, won't it change something? Do i need to rebuild the previously existed indexes?, or it is not needed.

    Thanks

    IgorMi

    I think you want to know that whether deleting few indexes on a table can make other indexes (on the same table) fragmented?

    If this was your question, i think the answer is NO. Deleting any non-clustered index on a table doesn't increase the fragmentation of other indexes.

    Sujeet Singh