Disabling Clustered Indexes
The following additional guidelines apply to disabling clustered indexes:

The data rows of the disabled clustered index cannot be accessed except to drop or rebuild the clustered index. This means the following:


These operations will fail: SELECT, UPDATE, DELETE, INSERT, CREATE INDEX, CREATE STATISTICS, UPDATE STATISTICS (on the index), and ALTER TABLE statements that modify table columns or constraints.


These operations will succeed: CREATE VIEW, DROP VIEW, CREATE TRIGGER, DROP TRIGGER, DROP INDEX, ALTER TABLE ENABLE/DISABLE TRIGGER, TRUNCATE TABLE, and DROP TABLE.


Nonclustered indexes cannot be created while the clustered index is disabled.


Existing nonclustered indexes and XML indexes associated with the table are automatically disabled and cannot be accessed.


All clustered and nonclustered indexes on views that reference the table are disabled. These indexes must be rebuilt just as those on the referenced table.