I used the script from this blog to identify the unused index on my database. It returns an index which is on a column called result where I have a check constraint on that column.

So removing this index will impact the check constraint performance?


will removing this index impact the check constraint performance?

No, it will not.

Check constraints only operate on the columns of a single row, not on multiple rows. So it is completely unaffected by the existence (or absence) of an index.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.