In article <362f1d08.19766053_at_news.siol.net>, jmodic_at_src.si (Jurij Modic) wrote:
>On Thu, 22 Oct 1998 11:37:36 +0200, "Itai Gan" <itaig_at_ncc.co.il>
>wrote:
>
>>does anyone know if inserting null numbers into a table create the space in
>>the disk or not???
>
>If the column containing NULLs is the last column in a table
>definition then no disk space is occupied with those null values. If
>the column is not the last one then 1 byte per null is occupied.
The short answer is that the length byte(s) for a column will always be used
even if just to store a zero - for a null column value. (Like he said.)
Received on Sun Oct 25 1998 - 23:09:50 CST
