Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Maximum of Columns in one table (9i)
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