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: Rick Denoire <100.17706_at_germanynet.de>
Date: Sat, 08 Nov 2003 23:06:12 +0100
Message-ID: <q1qqqvcjir420f9islgvhghftknl39vk39@4ax.com> 





"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote:




>In Enterprise Edition query rewrite. In any edition it can be part of a

>refresh group.




So I am afraid that materialized views won't buy us anything.
Developers create them without the enable query rewrite option. I set
this option whenever I notice that it is missing, but very soon it
will be recreated without it.



Rick Denoire
Received on Sat Nov 08 2003 - 16:06:12 CST












Original text of this message













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