3 ms·
Why not just use an audit table, to keep from littering your indices?
by silisili 4y ago
Why not just use an audit table, to keep from littering your indices?
- jacobr1 4y agoYou still need a record of the data, which probably isn't fully captured in the audit table
- jelkand 4y agoAn audit table is a similar, but not entirely equivalent tool. There are circumstance where both audit tables / soft deletes are appropriate, and where only one of the two is. Other systems that work are append-only tables, event driven systems, and I'm sure there are more that I'm not aware of.