Re: Views on views

On Tue, 10 Sep 2002, M.Biervliet1_at_chello.nl wrote:
> Hi, my question is
> Will a view on a single view decrease performance?
>
> There are no joins in non of the views, just a one on one relation
> (different scheme's, some columns omitted)

A single view is representing a table and you want to join them?

There shouldn't be any decrease in performance compared to directly joining the tables.

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