Are trailing null columns stored?
Date: Fri, 4 Jun 1993 13:48:37 GMT
Message-ID: <1993Jun4.134837.18974_at_uvm.edu>
V6 System Architecture training Doc (page 1-40) states:
"Trailing null fields not stored"
I tried a test. I inserted a row with both an embedded null column (field)
and some trailing null fields. After a commit and checkpoint, I dumped the
relevant Oracle block. It appears that both the embedded null field and
the trailing ones use one byte of disk storage each -- it's value is x'ff'.
This is of limited practical significance (since we don't have many rows
with trailing null fields), but I am curious what the facts really are.
Does anyone have a definitive answer?
We are running Oracle 6.0.34.3.1 (TPO) under AIX 3.2.
Warren Van Wyck University of Vermont wvw_at_moose.uvm.edu (802)656-8421
--
Warren Van Wyck Analyst/Programmer (802)656-8421
University of Vermont, Computing and Information Technology
Internet: wvw_at_moose.uvm.edu
Received on Fri Jun 04 1993 - 15:48:37 CEST