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: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 9 Jul 2002 17:03:17 +1000
Message-ID: <lOvW8.31132$Hj3.94303@newsfeeds.bigpond.com>


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
> ******************************************
>
>
Received on Tue Jul 09 2002 - 02:03:17 CDT

Original text of this message

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