Re: Sorting problems oracle 9i

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 31 Dec 2004 21:12:00 -0800
Message-ID: <41d63003$1_4@127.0.0.1>

Mark Bole wrote:

> 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

I interpreted the word "dynamic" as meaning the SQL statement underlying the MV couldn't be changed on-the-fly.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Fri Dec 31 2004 - 23:12:00 CST