RE: MATERIALIZED VIES IN OLTP SYSTEM : GOOD OR NOT
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <s.sethi@xxxxxxxxxxxx>
- Date: Thu, 1 Jun 2006 22:47:15 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
