RE: Sanity check re. layering of views

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Wed, 16 Mar 2005 09:46:03 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0704AC034C@exchsen0a1ma>

I don't think it's reasonable to create any layers of views. It's cheaper and easier to create a brand new view. Cheaper in that when the query goes bad, it's easier to debug and manage. And Easier speaks for itself.

-----Original Message-----

From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca] Sent: Wednesday, March 16, 2005 9:09 AM
To: ORACLE-L
Subject: Sanity check re. layering of views

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
--

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