"Rath.Yelandur" <Rath.Yelandur_at_Spam.Nope> wrote in message news:<3f09b0ab_at_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".
Received on Mon Jul 07 2003 - 18:24:17 CDT
