Re: Computed column?

Steve,

  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.

  Your thoughts? Anybody else?

Chuck

In article <01bc922b$bb169680$160a14ac_at_SteveIP.corp.sierra.com>, "Steve McDaniels" <steve.mcdaniels_at_sierra.com> wrote:
>Uh, isn't kinda bad relational form (i.e., violates the 3rd Normal rule) to
>store, in a table, a field which can be entirely derived from some other
>fields in the same record of the table?
>
>
>Jane Mikityanskaya <jane_at_hnrc.tufts.edu> wrote in article
><33CA84D9.A866545C_at_hnrc.tufts.edu>...
>> Working with Oracle Rdb, I was spoiled by possibility of creating
>> 'computed by' columns.
>> For example, creating table ' Test' I could define:
>> column A integer,
>> column b integer,
>> column c as (a+b)/10;
>> Since there is no such feature in Oracle 7.3, can someone tell me a work
>> around for 'computed' fields?
>>
>> Regards,
>> Jane
>>
>>
>>
  Received on Wed Jul 23 1997 - 00:00:00 CDT