Re: Sanity check re. layering of views

On Wed, 16 Mar 2005 10:57:26 -0500, rachel carmichael
<wisernet100@xxxxxxxxx> wrote:
> the problem with layering views comes in when you try to fix
> performance problems -- how do you tune the highest level view? All
> you need is one badly tuned query in one of the lower level views and
> your performance goes through the floor

and the associated issue that instead of trying to tune one query
against a set of base tables you are 'tuning' multiple sets of sql
(all the sql that gets issued against the view for whatever purpose)
in one place. So you tend to fix your problem at the expense of other
parts of the system that you didn't know used that view.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l

Other related posts: