On Tue, Sep 16, 2003 at 09:58:32AM -0400, Randy Chrismon wrote:
All this discussion about the definition of NULL and its use in
database querying has been most interesting and enlightening. I
hadn't realized I was asking such a deep question. Unfortunately, I'm
still at the stage of designing
The performance benefit to be had with NOT NULL columns comes from the
fact that a NOT NULL column can be of fixed length (allowing for fixed
length records). Using NOT NULL probably wont offer any benefit on a
VARCHAR column, since VARCHAR columns are not of fixed length to begin
with.
-JF