Re: Materialized Views query without refresh?
- From: Mark Bole <makbo@xxxxxxxxxxx>
- Date: Wed, 01 Jun 2005 10:28:43 -0700
While doing so, you might also include the topic of query re-write, if
in a data warehouse environment.
In other words, to the statement "Querying the materialized view has
nothing to do with the refresh", I would add: if a materialized view is
stale, it won't be used for query re-write. (unless you use something
like "QUERY_REWRITE_INTEGRITY=stale_tolerated" -- there's a lot more
info in the Data Warehousing Guide).
-Mark Bole
Denham Eva wrote:
> It appears my understanding of these views is far more incorrect than I
> expected.
> It appears I will have to do some serious RTFMing.=20
>
>
> -----Original Message-----
> From: Yasin Baskan [mailto:yasbs@xxxxxxxxxxxxxx]=20
> Sent: 01 June 2005 02:34 PM
> To: Denham Eva; oracle-l@xxxxxxxxxxxxx
> Subject: RE: Materialized Views query without refresh?
>
>
>
> Am i getting it wrong? Querying the materialized view has nothing to do
> with the refresh. Querying does not refresh materialized views.
> Force is one of the refresh methods available. It tries to do a fast
> refresh if possible, complete refresh otherwise when you want to refresh
> the materialized view (if you created it as to be refreshed on demand it
> will be refreshed when you want, if you created it as to be refreshed on
> commit it will be refreshed on commits to the master table.)
> [...]
--
//www.freelists.org/webpage/oracle-l
Other related posts:
