Re: Computed column?

From: George Faison <most_at_i3va.com>
Date: 1997/08/02
Message-ID: <33e2842f.4488803@news.i3va.com>#1/1

On Wed, 23 Jul 97 23:18:41 GMT, bayes_at_earthlink.net (Chuck Bayes) wrote:

>
> I'm kinda new to the DBA world, but I would think that while populating a
>calculated field from fields within the same table does violate 3rdNormal, the
>benefit in terms of performance out weighs strictly adhering to normalization.
>

Depends. Might be OK in a data warehousing type application, but in an operational database violating 3rd normal form usually always leads to problems down the road, IMHO.

Cheers! Received on Sat Aug 02 1997 - 00:00:00 CDT