• 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