From: "Rath.Yelandur" Newsgroups: comp.databases.oracle.misc Subject: Materialized Views + User defined Functions Date: Mon, 7 Jul 2003 13:40:32 -0400 Lines: 12 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 63.104.15.5 Message-ID: <3f09b0ab@shknews01> X-Trace: shknews01 1057599659 63.104.15.5 (8 Jul 2003 01:40:59 +0800) Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!novia!newscene.com!newscene!novia!novia!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!nntp.gblx.net!news2.ilink.net!shknews01 Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:129123 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. Can anyone confirm if this is truly the fact. If that is the case, Is there a work around for this problem.