Possible Duplicate:
Why shouldn't we allow NULLs?

I've heard that it's a bad idea to do database design such that nullable fields exist. However, eliminating nullables often cause much more complex schemas.

Given a schema where elimination of the NULL is considerably more complex (e.g. replace any instance of NULLs with a separate table which gets JOIN'd), or using a nullable field, which is the better action, and why?

| improve this question | | | | |

Browse other questions tagged or ask your own question.