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

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 06 Jul 2005 11:54:38 +0200
Message-ID: <lbanc1l78ochosqf8p8dipgqkvvbld8vo2@4ax.com>

On Tue, 05 Jul 2005 08:14:28 -0700, DA Morgan <damorgan_at_psoug.org> wrote:

>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.

Isn't the required number a functional issue? If an entity has more than 40 attributes what am I to do in your opinion? Surely not design more than one table with one-to-one relations just to keep under your limit?

Jaap. Received on Wed Jul 06 2005 - 04:54:38 CDT