Re: Oracle 9i and null values

On 9 Jul., 14:34, sybrandb <sybra..._at_gmail.com> wrote:
> On 9 jul, 14:27, "alexander.stuckenh..._at_fernuni-hagen.de"
>
>
>
>
>
> <alexander.stuckenh..._at_gmail.com> wrote:
> > Hi all,
>
> > I have a question regarding null values in tables. In the db-handbook
> > it is said, that null values at the end of a row do not consume disk
> > space at all as the header of the next row indicates the beginning of
> > a new entry.
>
> > But what is with null values somwhere else in a table? How much disk
> > space does such a null value consume? If have a table with lots of
> > null values and would like to know how valuable it is to redesign the
> > structure to save disk space.
>
> > Best regards,
>
> > Alex
>
> The number of bytes will equal the number of length bytes, so 2 for
> varchar2, etc.
>
> --
> Sybrand Bakker
> Senior Oracle DBA- Zitierten Text ausblenden -
>
> - Zitierten Text anzeigen -

So, if I have e.g. number(p, s): How much space uses a NULL?

Thanks so far,

Alex Received on Mon Jul 09 2007 - 08:23:30 CDT