BIRT 3.7
Written by: Michael Williams
Featured Refcardz: Top Refcardz:
  1. Scrum
  2. Apache Maven 2
  3. Essential MySQL
  4. Node.js
  5. Groovy
  1. jQuery Selectors
  2. Ajax
  3. Java
  4. Spring Config.
  5. Java Concurrency

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
  • 1050
  • 1

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)