Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Maximum of Columns in one table (9i)

Re: Maximum of Columns in one table (9i)

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 06 Jul 2005 09:34:01 -0700
Message-ID: <1120667666.48278@yasure>


Tony Andrews wrote:

> This is getting silly. The right number of columns for a table is not
> "under 14" or "under 50", it is whatever number of columns you get
> after normalisation. If every column is functionally dependent on the
> key then the table is normalised, even if it does contain 17 columns or
> 57.

You are misunderstanding the intention of our comments. Of course you are correct. What we are trying to give the OP is a rule-of-thumb by which to be alerted that further examination may be required.

And anyway we all know the number is 42. ;-)

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Jul 06 2005 - 11:34:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US