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
Received on Mon Jul 09 2007 - 07:34:03 CDT
