Re: Do columns with Null data take up space?

From: Tim Kearsley <tim.kearsley_at_milton-keynes.gov.uk>
Date: 3 Dec 2004 01:27:40 -0800
Message-ID: <725736ef.0412030127.57fced1b@posting.google.com>

To quote from the 9i Concepts Manual:

"To conserve space, a null in a column only stores the column length (zero). Oracle
does not store data for the null column. Also, for trailing null columns, Oracle does
not even store the column length."

Hope that helps.

Regards,

Tim Kearsley

douglas_at_igmax.com (Doug) wrote in message news:<8eb5e9ba.0412021729.10ebca78_at_posting.google.com>...
> If I create a table with 250 columns, and only fill 8, do the other
> columns take up space? (My user wants to log tests. There can be as
> many at 250 tests in a set, but normally only about 8. My user wants
> one record per set so he can run some third party analytical software
> against the test results.) Is Oracle 8i smart enough to compress the
> null values down so they don't take up space if they are unused?
Received on Fri Dec 03 2004 - 03:27:40 CST