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

Home -> Community -> Mailing Lists -> Oracle-L -> Sanity check re. layering of views

Sanity check re. layering of views

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Wed, 16 Mar 2005 10:09:07 -0400
Message-id: <1A4AC4BAB9C50A42854582B69B08C03407E075DE@MSGMARBIO05>


I am being told that where there are five layers of views, it's because the design of the base tables no longer meet requirements.

So they build views upon views.

Do you think it's reasonable to see five layers of views?

My instinct it would be ideal to have at most three layers of views. That perhaps it's more an issue of the design of the queries used to retrieve the data.

Patrice.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 16 2005 - 09:16:46 CST

Original text of this message

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