Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Views on views

Re: Views on views

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 10 Sep 2002 21:44:53 GMT
Message-ID: <3D7E67A9.E5C89C8E@exesolutions.com>

Marcus Biervliet 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)
> Thanks.

Yes.

There is rarely a reason not to combine the views into a single view.

Daniel Morgan Received on Tue Sep 10 2002 - 16:44:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US