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

Joe Sam Shirah

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.

0 Comments  (click to add your comment)
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



About | Sitemap | Contact
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.