Re: Views on views

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 11 Sep 2002 20:15:28 GMT
Message-ID: <3D7FA433.A2B320BB@exesolutions.com>

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.
>
> --
> Galen deForest Boyer
> Sweet dreams and flying machines in pieces on the ground.

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.

Daniel Morgan Received on Wed Sep 11 2002 - 15:15:28 CDT