By submitting your information, you agree that jguru.com may send you jGuru offers via email, phone and text message, as well as email offers about other products and services that jGuru believes may be of interest to you. jGuru will process your information in accordance with the Quinstreet Privacy Policy.

I've heard that I can save space by allowing NULLs for columns where no value is supplied. Is that correct?

While the answer is ultimately dependent on your specific DBMS, most databases create an extra byte for every null capable column to mark whether or not it contains a null value. This clearly means that more space is used and processing time is also usually longer, since the additional byte value must be checked.