Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Size of "0" versus NULL ?
How about finding out yourself. Do a vsize on a row and column that has a 0
for the number
select vsize(myColWith_zero) from mytable where to chose a specific row.
You are probably talking 1 or 2 bytes for a 0 and 1 byte for a null so it's
not a lot of space and how do you distinguish a null from a 0 then?(no data
from a value)
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Frank Rizzo" <franklynrizzo_at_REMOVE_THIS_BIT.today.com.au> wrote in message news:MPG.18baeb03eee05080989684_at_news.cdn.telstra.com.au...Received on Mon Feb 17 2003 - 00:20:48 CST
>
> 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.
> >
> >
> >