Table with clustered index is totally depended on index accessibility.
ERROR : The query processor is unable to produce a plan because the index ‘IND_TABLE’ on table or view ‘Table’ is disabled.
REASON : We find that some disable the cluster index due to which issue occur. Clustered index physically sort & save data in pages. When clustered index is disable, DB engine is not able to access data although data is available with table.
SCREENSHOT :
Note :
· There is no option to ENABLE the Index. You have to REBUILD or DROP & RECREATE it.
· This is not the case with non-clustered index.
If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun
Reference : Rohit Garg(http://mssqlfun.com/)
