Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Comparing mat. views with regular tables

Re: Comparing mat. views with regular tables

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Sat, 08 Nov 2003 05:58:18 GMT
Message-ID: <_B%qb.5469$y95.944@nwrdny01.gnilink.net>

"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:pmdoqv4u7pilc1t10u4d9rvfs8e4kjqqo6_at_4ax.com...
> Let's suppose I have a materialized view which:
> -must be refreshed with the method "complete" across a DB-link
> -is not updatable
> -will refresh using a cron job
>
> then, couldn't I accomplish the same using a regular table, which will
> be truncated and filled regularly with the same basic definition as
> the materialized view?
>
> Which would be the advantage of a materialized view in this case?
>
> Thanks
> Rick Denoire

Query Rewrite Capability .. to name one.

Anurag Received on Fri Nov 07 2003 - 23:58:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US