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