RE: MATERIALIZED VIES IN OLTP SYSTEM : GOOD OR NOT

Hi

>On 05/29/2006 05:52:26 AM, Sachin Sethi wrote:
>> HI
>>
>> IT IS BENIFICIAL TO HAVE MATEREIALIZED VIES IN OLTP SYSTEM
>> PLEASE HELP ME
>
>It is definitely beneficial to release the Caps Lock key. You've gotta ask
>yourself one question: what do you want that MV for? Can you tolerate data
>being refreshed at discreet intervals or do you really need them in real time?
>As one great DBA has put it, you can't always get what you want but you can try
>sometimes.
>
>--
>Mladen Gogala

I agree with Mladen. That said, I successfully used MV in OLTP system twice for performance reasons. The first time with a fast refresh every minute (or something like that), the second time with a fast refresh on commit.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l