Re: Materialized Views query without refresh?

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_at_kocbank.com.tr]=20
> Sent: 01 June 2005 02:34 PM
> To: Denham Eva; oracle-l_at_freelists.org
> 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.)
> [...]

--
http://www.freelists.org/webpage/oracle-l