Hi
You can disable an index. Once you disable it, then you have to rebuild it in order to enable it.
If your index is clustered, then after disabling it, your data will be read only and you must rebuild it for update operations.
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com