Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!nx01.iad01.newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
From: "chao_ping" <zhuchao@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle Performance Issue
Date: 9 Sep 2005 21:32:09 -0700
Organization: http://groups.google.com
Lines: 9
Message-ID: <1126326729.083547.240490@g14g2000cwa.googlegroups.com>
References: <3o7s29F2dcvrU1@uni-berlin.de>
   <1126098359.291566.8030@g44g2000cwa.googlegroups.com>
NNTP-Posting-Host: 211.161.216.109
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1126326736 5623 127.0.0.1 (10 Sep 2005 04:32:16 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 10 Sep 2005 04:32:16 +0000 (UTC)
In-Reply-To: <1126098359.291566.8030@g44g2000cwa.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5) Gecko/20031007,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=211.161.216.109;
   posting-account=XoF4cA0AAACZeACjsR3SGb05DqyXqF0b
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251225

with MVIEW, you have to have that group by?
for group by , fast refresh maybe does not work.

So every dml on that table result a delete the mv and full refresh of
that mv.
That's terrible!

Do you mean high version oracle support fast refresh on "COMPLEX" SQL?