List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 28 2002 10:56pm
Subject:Re: Penalty for non-null defaults ?
View as plain text  
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

Thread
Penalty for non-null defaults ?Charlie29 Jul
  • Re: Penalty for non-null defaults ?Paul DuBois29 Jul
    • Re: Penalty for non-null defaults ?Keith C. Ivey30 Jul
      • Re: Penalty for non-null defaults ?Jeremy Zawodny30 Jul