Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using views inside a View
GreyBeard wrote:
> On Mon, 21 Feb 2005 21:23:23 +0100, Frank van Bortel wrote:
>
>
>>>Please correct my interpretation of your statement: >>> >>>"Selecting from inappropriate views that do unnecessary work [relative >>>to what is needed by the select] can lead to bad execution plans. >>> >>>Therefore selecting from views is bad." >>> >> >>No - I don't go that far; I'd like to change that to: >>therefore selecting from nested views should only be done >>with caution by knowledgeable developers. >> >>>In some circumstances (such as publishing views to ad-hoc users) I can >>>concur that data sources can be used inappropriately. >> >>Meet Mr. Murphy! Mr. Murphy is an optimist.
-- Regards, Frank van BortelReceived on Tue Feb 22 2005 - 03:19:52 CST
![]() |
![]() |