Re: Oracle 9i and null values

>From the concepts manual...

Nulls are stored in the database if they fall between columns with data values. In these cases they require 1 byte to store the length of the column (zero).

Trailing nulls in a row require no storage because a new row header signals that the remaining columns in the previous row are null. For example, if the last three columns of a table are null, no information is stored for those columns. In tables with many columns, the columns more likely to contain nulls should be defined last to conserve disk space.

So looks like no matter what the datatype, a NULL value is represented by 1 byte.

JR Received on Tue Jul 10 2007 - 12:19:45 CDT