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
http://www.mgogala.com
--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 29 2006 - 10:56:29 CDT
