Re: Size of "0" versus NULL ?

Hi,

I have not had any reply and I was wondering if I've asked something that is a FAQ (can someone point me to a faq, document, manual, or anything else so i can work this out).

In article <MPG.18adb55b35fd6ff4989683_at_news.cdn.telstra.com.au>, franklynrizzo_at_REMOVE_THIS_BIT.today.com.au says...
>
> Greetings,
>
> I have a table with NUMBER(4). The table has ~ 7 million records. I
> want to know what the space saving is if i convert all the zeroes to
> NULLs ?
>
> How do I go about calculating this accurately.
>
> It will be something like:
>
> 7 million * (sizeof zero - sizeoff NULL) ??
>
> How do I find the size of storing a single zero (does it change if the
> column was NUMBER(30), for instance ???) and the size of storing a NULL.
>
> Thanks in advance for any info.
>
>
>
Received on Sun Feb 16 2003 - 19:50:50 CST