From: news@abc.co.uk (Peter L)
Newsgroups: comp.databases.oracle.server
Subject: Re: materialized views (snapshots)...
Date: Wed, 08 Aug 2001 22:44:34 GMT
Lines: 12
Message-ID: <3b71a4eb.12702992@news.freeserve.net>
References: <9jq453$2idr$1@oak.cise.ufl.edu>
NNTP-Posting-Host: modem-56.bald-eagle.dialup.pol.co.uk
X-Trace: newsg1.svr.pol.co.uk 997310657 23549 62.137.168.56 (8 Aug 2001 22:44:17 GMT)
NNTP-Posting-Date: 8 Aug 2001 22:44:17 GMT
X-Complaints-To: abuse@theplanet.net
X-Newsreader: Forte Free Agent 1.21/32.243


On Thu, 26 Jul 2001 18:06:29 -0400, "Joachim Hammer"
<jhammer@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?