Do not forget all cascaded updates and deletes. If you only set the flag, you will still need to perform those. What would be the big advantage of doing this? > I am wondering why do we have a borrowers and a deletedborrowers tables > when a "delete" flag in the borrowers table could do the trick.