• 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

    Igor Micev,My blog: www.igormicev.com