I move the record to another _index_, generally.
It depends whether you reliably control all the DB client code, of course.
It depends whether you reliably control all the DB client code, of course.
It then turns into a slowly-growing problem if you never ever clean up the soft-deleted records, but just being able to gain auditability nearly immediately is usually well worth kicking the can down the road.