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

From: tina london <tinalondon_at_demon.co.uk>
Date: Wed, 6 Jul 2005 14:41:09 +0100
Message-ID: <dagn1a$gq5$1$8300dec7@news.demon.co.uk>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1120576489.605976_at_yasure...
> eagle.f_at_gmail.com wrote:
> > Columns
> >
> > Per table
> >
> > 1000 columns maximum
>
> Per sane design 40-50 column max. Above that number it is time to
> get someone to critique your design.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)

surely 40-50 columns is way too high and indicates a denormalised design, not that necessarily there is anything wrong with that, I would like to suggest anything with more that 10-14 columns is probably in need of attention.

step 1 produce a normalised model

step 2 denormalise to get the performance needed in critical areas Received on Wed Jul 06 2005 - 08:41:09 CDT