Sunday, 19 July 2026

 

What happens if Jr DBA disabled cluster Index ?
You cannot read data from the table. The query processor is unable to produce a plan because the index is disabled. 
Non-clustered indexes on the table are also unavailable because they depend on the clustered index (for clustered tables).

If Index is deleted, still you can read data but query performance is slower .


What are the Differences between Covering Index and Included Index in SQL server?



No comments:

Post a Comment