Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sjc70.webusenet.com!news.webusenet.com!news.isc.org!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: JusungYang@yahoo.com (Jusung Yang)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Materialized Views + User defined Functions
Date: 7 Jul 2003 16:24:17 -0700
Organization: http://groups.google.com/
Lines: 15
Message-ID: <130ba93a.0307071524.5391145@posting.google.com>
References: <3f09b0ab@shknews01>
NNTP-Posting-Host: 64.172.46.174
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1057620258 10393 127.0.0.1 (7 Jul 2003 23:24:18 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 7 Jul 2003 23:24:18 GMT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:129115

"Rath.Yelandur" <Rath.Yelandur@Spam.Nope> wrote in message news:<3f09b0ab@shknews01>...
> We want to use MATERIALIZED VIEWS to overcome performance problems with
> views processing Millions of records.
> We are currently using Oracle Enterprise 8.1.7.
> 
> One of my friends mentioned that M-View does not recognise User Defined
> functions.

Not exactly. You can use UDF to create an MV. But problems will come
when you try to "fast refresh" it, as it is considered "complex" and
can only be complete refreshed. Problems may also come when you try to
use "query rewrite" - unless the UDF is declared "deterministic".


- Jusung Yang