On Mar 18, 10:35*pm, Michael Austin <maus...@firstdbasource.com>
wrote:
> It does make sense - just be aware that your applications would need to
> include "and rec_deleted is null" or similar in all of your other sql
> that operates on those tables (select, insert, update) to ensure you are
> not operating on data you supposedly deleted.
>
> Of course the biggest factor here is time and effort. Is it going to
> take you more time to add the deleted column (very easy) + modifying
> your code than it is really worth? *Does it really take you that long to
> "purge" old data?

Could I not use a view to do this? (Don't know much about views mind)