I have also read that allowing a field to be NULL slows down your queries.
- Kirk Cerny
----- Original Message -----
From: "Steve Dibb" <[EMAIL PROTECTED]>
To: <[email protected]>
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 |
`==================================='
.===================================.
| This has been a P.L.U.G. mailing. |
| Don't Fear the Penguin. |
| IRC: #utah at irc.freenode.net |
`==================================='
