Re: Views on views

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 11 Sep 2002 20:55:09 -0500
Message-ID: <uhegvztpl.fsf@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.
>>
>> --
>> 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.

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.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.

Received on Wed Sep 11 2002 - 20:55:09 CDT