Re: NULL versus NOT NULL usage
From: IMTB Data Management <datamgmt_at_istar.ca>
Date: 1998/06/01
Message-ID: <3572F27A.163A_at_istar.ca>#1/1
Date: 1998/06/01
Message-ID: <3572F27A.163A_at_istar.ca>#1/1
RABK wrote:
>
> I am researching the benefits of NOT NULL versus NULL datatypes and am
> interested in the viewpoints of the exp dba, client developers.
>
> Describe the benefits of using a table that has NOT NULL versus a NULL data
> type.
>
> Do NULLS in general cause more heartache for client developers? Why?
>
> Do NOT NULL save enormous amounts of space.
>
> What issues arise from querying fields that have NULLS in them?
Null can save space but they also require additional space for the null indicator on every column. You'll have to do the math for your particular use of the column.
Rick Gebethner Received on Mon Jun 01 1998 - 00:00:00 CEST