alexander.stuckenholz_at_fernuni-hagen.de wrote:
> 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
SELECT sys_op_map_nonnull(NULL) FROM dual;
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Jul 09 2007 - 08:37:49 CDT
