In message <1133405782.053859.96820_at_g44g2000cwa.googlegroups.com>,
DaLoverhino <DaLoveRhino_at_hotmail.com> writes
>Hello. Suppose I have a table with these fields:
>
>id1 number
>id2 number
>id3 number
>name varchar2(40);
>address varchar2(200);
>description varchar2(4000);
>
>If name, address, and/or description is null, would the physical disk
>space that row inhabits be smaller than say if the fields were
>non-null? It probably depends on the environment, right? And if so,
>what things should I be looking into? And, in your experience, what do
>you typically see?
IF all three are null, then nothing is stored. If name and address are
null, but description is not null then a place holder is stored for each
null column. 2 bytes each iirc.
--
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>
Received on Thu Dec 01 2005 - 01:20:18 CST
