What is your goal by doing a soft delete? 1. If the reason is because you need to access those data in the future, an archive table is great for your purpose. 2. You added IsDeleted column in your table for soft delete? You have to know you are creating unnecessary query on this column.