Re: So what's null then if it's not nothing?

From: Alexandr Savinov <>
Date: Wed, 23 Nov 2005 12:47:56 +0100
Message-ID: <438456fe$>

Jon Heggland schrieb:
> In article <>,
> hugo_at_pe_NO_rFact.in_SPAM_fo says...

>>>2- You create a parent/root entity/table and make a subtype for each
>>>optional field
>>And that would lead to an exponential explosion of tables. With one
>>optional attribute, you get two subtypes. Two optional attributes means
>>four subtypes. With 10 optional attributes, you'd need no less than
>>1,024 tables.

> You mean you would create a table for each *combination* of attributes?
> What on earth for?

In order to avoid nulls (there is an opinion that they need to be removed from schema).

Received on Wed Nov 23 2005 - 12:47:56 CET

Original text of this message