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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle and (Cached?) Views

Re: Oracle and (Cached?) Views

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 09 Jul 2002 19:43:47 +0100
Message-ID: <3D2B2EE3.4C06@yahoo.com>


Richard Foote wrote:
>
> Hi Niall,
>
> I never was much of a salesman :)
>
> Now that I've thought about it for a tad longer, I'm not convinced that
> views are actually ever cached in the DD so there goes that idea !!
>
> Regards
>
> Richard
> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
> news:3d2a79f2$0$232$cc9e4d1f_at_news.dial.pipex.com...
> > "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> > news:iduW8.31065$Hj3.93786_at_newsfeeds.bigpond.com...
> > > You're currently on 8.0 but on 8i we get to meet Materialized Views that
> > > rather than be just being stored code is the actual summarized data as a
> > > segment in it's own right. This means that the statement doesn't have to
> > > reexecute upon the underling tables but can access the pre-summarized
> data
> > > again and again. Potentially offering huge savings and performance
> > > improvements.
> > >
> >
> > They are a little better than that. Not only do they act as pre summarized
> > data *exactly* like a cached view but also the optimiser will use them
> when
> > a query is created on the underlying data that could be answered using the
> > view.
> >
> > You should upgrade if you can but in Version 8 you can use snapshots not
> for
> > their purpose in replication but as a kind of cached (and probably a bit
> out
> > of date) view within a database.
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> > ******************************************
> >
> >

Yup - in high parse systems, you often see 'select ... from view$' being a 'major player'

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Tue Jul 09 2002 - 13:43:47 CDT

Original text of this message

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