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