Re: materialized views (snapshots)...

From: Peter L <news_at_abc.co.uk>
Date: Wed, 08 Aug 2001 22:44:34 GMT
Message-ID: <3b71a4eb.12702992@news.freeserve.net>

On Thu, 26 Jul 2001 18:06:29 -0400, "Joachim Hammer" <jhammer_at_cise.ufl.edu> wrote:

>
>Has anybody been able to the query rewrite feature to work? Any input or
>suggestions are greatly appreciated.
>

We didn't have any problems getting queries to rewrite. Have your views gone stale? You can checkin user_mviews.staleness. If they are stale, after dml on the underlying table, rewrite won't take place unless you have set query_rewrite_integrity (?) to stale tolerated. Also have you analyzed your mviews? Received on Wed Aug 08 2001 - 17:44:34 CDT