Re: Table design and not null columns

"Teresa Huntsman" <thuntsma_at_uiuc.edu> wrote in message news:3ABF97E5.671EAB79_at_uiuc.edu...
> Sorry if this has been asked before.
>
> Is it true that good table design has all the "not null" columns first
> in the create statement with nullable columns following? Someone told
> me that they thought this allows for more efficient data storage and
> data retrieval. I couldn't find any information about this.
>

This is true. A trailing null allowed column with the value null is not stored at all.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Mar 26 2001 - 14:01:21 CST