| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: So what's null then if it's not nothing?
Jon Heggland schrieb:
> In article <kfa7o1d714eqdnlfnaik6t1gs6uv4l0b09_at_4ax.com>,
> 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.
In order to avoid nulls (there is an opinion that they need to be removed from schema).
-- http://conceptoriented.comReceived on Wed Nov 23 2005 - 05:47:56 CST
![]() |
![]() |