Re: Penalty for non-null defaults ?

[Paul DuBois]

At 14:34 -0700 7/28/02, Charlie wrote:
>Is there any storage / performance penalty for specifying '' or 0 as default
>values, as opposed to allowing null's in the table structure?

NULL values take less storage space.  (One bit per NULL value in a row,
if I remember correctly).

>
>sql, query
>
>Thanks,
>Charlie