Re: Oracle and (Cached?) Views

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