users table where a row can be marked for future deletion, so I'm looking for the best way to do this.
I've thought of two options so far:
Every night a process will query the table and get all users that match
delete_datewith current date and delete them.
users_to_be_deletedtable with the
idof the row in
userstable to be deleted along with a
Every night a process will query
userstable and join on
users_to_be_deletedin order to identify which users should be deleted (matching
delete_datewith current date), and then delete them.
Basically, Option 1 adds a column that can (and in most cases will) contain
NULL marks, while Option 2 has no columns that accept
NULLs at all, but will require an additional
Considering that most users will not be marked for deletion (an estimate is that only 10-20% will), which option is the most efficient? What are the pros and cons of each option?