I applied a non clustered index on the table which we have tested. We have also applied the index on our other sites with no issues.

This is one of...