SQL Server Interview: Can disable the Index, If yes, how to verify disable indexes?

This post is for SQL Server developers who are in intermediate level. Why people are asking this question because when you are performing any optimization related activity at that time, you need to test lots of indexes.

In that case, I have found many of developers who are dropping and creating indexes again and again for their testing purpose.

If you are good T-SQL Developer, you must know that you can also enable and disable the indexes. So I am sharing this interview question…

How to disable the index?

How to enable the index?

How to check the status?

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of