Re: Oracle View Machanism - Opinions Please!!!!!!

From: <randy67_at_delphi.com>
Date: Thu, 12 May 94 03:36:54 -0500
Message-ID: <5qyudKO.randy67_at_delphi.com>


Michael j Dorey <scoec_at_westminster.ac.uk> writes:  

>Does anyone on this system have any views/comments etc. on the use of the
>Oracle (SQL) view mechanism? This is a peeve directed to a particular
>lecturer here (who will remain nameless) but who is under the impression
>that when designing a database you should not create views which are
>themselves based (or partly based) on other views. When I questioned 'why?'
>I was given no specific reasoning. The solution to many database problems
 

My understanding is that it generates a tremendous performance hit Received on Thu May 12 1994 - 10:36:54 CEST

Original text of this message