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

Home -> Community -> Usenet -> c.d.o.server -> Re: is there any point to use materialized view without db link?

Re: is there any point to use materialized view without db link?

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 13 Oct 2005 09:33:47 -0700
Message-ID: <1129221212.982758@yasure>


niy38_at_hotmail.com wrote:
> in that secenario, a view seem more meaningful: without use extra space.
>

In WHAT scenario?

Most of the value of Materialized Views has nothing to do with db links. I would suggest a quick review of query rewrite and data warehousing.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Oct 13 2005 - 11:33:47 CDT

Original text of this message

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