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: Sorting problems oracle 9i

Re: Sorting problems oracle 9i

From: Mark Bole <makbo_at_pacbell.net>
Date: Sat, 01 Jan 2005 01:12:47 GMT
Message-ID: <jOmBd.5303$yV1.1734@newssvr14.news.prodigy.com> 





DA Morgan wrote:



> csharpgeek wrote:

> 


>> Looked at this option but materialized views arent dynamic and this is
>> a query that gets run quite often. Possibly 100x per our with different
>> parameters.
>>




> 

> Materialized views aren't dynamic ... but queries against them can be.




REFRESH ON COMMIT for the MV?



-Mark Bole
Received on Fri Dec 31 2004 - 19:12:47 CST












Original text of this message













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