Good feedback! Keep it coming all!

I can see the advantage of having a date field. But I'd say that it would be best served in addition to the flag field, don't you think? The problem with only having a date field is that the 'active' records would either have NULL or a fake, way-future date in that field. Now, I hate fake data, so that leaves NULLs, and NULLs are not indexed. So, if we ended up with a large percentage of records deleted, we would never be able to make an index to help ourselves. Now, with a flag field, we can add that field to any index we like if it will help. So, while a 'date of deletion' field would definitely provide useful information, I'm thinking that we would still need a flag - were we to go that route.

Thoughts?

Again, ANY AND ALL THOUGHTS WELCOME!

- Chris