Link Details

Link 69106 thumbnail
User 225256 avatar

By mswatcher
via sqlblogcasts.com
Published: Mar 05 2008 / 08:48

Nullable columns cause a extra data to be stored in your table and index to identify if a column value is NULL. This is caused a NULL bitmap. you need one NULL bitmap 8 NULLable columns. So on table with multiple NULL columns the overhead may not be large.
  • 10
  • 1
  • 666
  • 320

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (10)



Voters Against This Link (1)