On Wed, 16 Mar 2005 10:57:26 -0500, rachel carmichael
<wisernet100_at_gmail.com> 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
Received on Wed Mar 16 2005 - 11:09:35 CST
