database design

[kirk]

I have also read that allowing a field to be NULL slows down your queries.

- Kirk Cerny


----- Original Message ----- 
From: "Steve Dibb" <steve at wonkabar.org>
To: <plug at plug.org>
Sent: Thursday, June 09, 2005 11:45 AM
Subject: database design


> I'm working on creating a new table in our database, and I'm wondering 
> -- why bother with the possibility of NULL values in a field?  It seems 
> like it always adds more work then its worth.
> 
> What's the benefit of adding the option of IS NULL when you usually have 
> to check to see if its also blank (field = '' OR field IS NULL)?
> 
> Steve
> .===================================.
> | This has been a P.L.U.G. mailing. |
> |      Don't Fear the Penguin.      |
> |  IRC: #utah at irc.freenode.net   |
> `==================================='