Re: Is denormalizing via views bad (read: slow)?

Jason,
FWIW ... How can I say it? ...Like this: why strive for static perfection in a fluid world ..... ;-)
Go for option (c) & include nice comments in the SPs.

best wishes
Michael
jglover_at_xtra.co.nz (Jason Glover) wrote in message news:<27b86948.0203171817.27d460a3_at_posting.google.com>...
> c) Implement a physical model that slightly denormalized version of my
> sexy logical model, encorporating whatever "hacks" may be required to
> remove the need for views or jugernaut stored procedures but that
> unshamedly prostitute the perfection of my logical DM.
>
> Have I perhaps had too much coffee?
>
> Personally I prefer the legability of (b), but I am wondering if the
> trade-of of all those nested views is ultimately going to hurt
> performance.
>
> Regards,
>
> JBoy
Received on Mon Mar 18 2002 - 11:39:28 CET