Re: How does Oracle7 store Nulls in Database
From: Neil Greene <ngreene_at_locws140049.shl.com>
Date: 1995/11/29
Message-ID: <ngreene.817616034_at_houws001.shl.com>#1/1
Date: 1995/11/29
Message-ID: <ngreene.817616034_at_houws001.shl.com>#1/1
billn_at_mcs.com (Bill Norswether) writes:
>In article <49c9gr$4ed_at_mercury.kingston.ac.uk>, k926739_at_king.ac.uk says...
>>
>>
>If a null value falls between columns with data values, they
>require one byte. Trailing nulls in a row require no storage.
>( For more info, see Chapter 5 of the Oracle Server Concepts Manual )
Meaning, in your table design and creation statements, put those columns you think will possibly have null values. Teachnically, this will save your some storage overhead.
-- Neil Greene Senior Oracle DBA / Unix System Administrator SHL Systemhouse, Inc. LA Outsourcing Center <HREF=mailto:ngreene_at_shl.com>Received on Wed Nov 29 1995 - 00:00:00 CET