A view isn't the same as a base table though is it? Materialised or not.
"Kenneth Downs" <knode.wants.this_at_see.sigblock> wrote in message
news:q0heq3-ghe.ln1_at_pluto.downsfam.net...
> Emily Jones wrote:
>
>>
>> I thought a table with a derived column in it ISN'T normalised.
>> Functionaly dependent not on the Primary Key, or something. No?
>>
>>
>
> Correct. But neither is the data in many views. Both are system
> controlled
> (if you go triggers) so whatever theory allows views allows the
> materialized columns.
>
> --
> Kenneth Downs
> Secure Data Software, Inc.
> (Ken)nneth@(Sec)ure(Dat)a(.com)
Received on Sun Aug 06 2006 - 02:04:53 CDT
