Re: Views on views

From: Arnoud Otte <arnoud.otte_at_dsslib.com>
Date: Sat, 14 Sep 2002 12:16:23 -0700
Message-ID: <am01u5$lmf$1@nnrp.atgi.net>

"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message news:uhegvztpl.fsf_at_hotpop.com...
> On Wed, 11 Sep 2002, dmorgan_at_exesolutions.com wrote:
> > Galen Boyer wrote:
> >
> >> On Tue, 10 Sep 2002, dmorgan_at_exesolutions.com wrote:
> >>
> >> > There is rarely a reason not to combine the views into a single view.
> >>
> >> Come on Daniel. This is just incorrect. Views are a great tool and
> >> can be used quite well for simplifying new sql.
> >
> > I agree. Views are a great tool. I use them all the time.
> > Views built on top of other views are not.
> >
> > And I've benchmarked this more than once.
>
> There isn't a rule-of-thumb on this. I've written views on views many
> times over that perform quite well.
>
> You do need to be quite cognizant of views on views and their
> performance, but to say that "views on views" just don't perform well is
> incorrect.

I tend to agree with Daniel. Performance drops rapidly with views-on-views, but being open to new experiences, please share some of the learnings you have had on getting performance out of views-on-views.

Arnoud. Received on Sat Sep 14 2002 - 14:16:23 CDT