Search SSWUG.ORG:



DATABASES

Disabling An Index Removes Index Data This is an off-site link.  Please review our Terms of Service for additional information.




(Shaun J Stuart) DBAs gained the ability to disable indexes in SQL Server 2005. This is a handy little option when you are tuning indexes or consolidating indexes. When you disable an index, you tell SQL Server to basically pretend the index doesn't exist.

Read this article...







comments powered by Disqus