Home » SQL & PL/SQL » SQL & PL/SQL » Materialized views
Materialized views [message #385625] Tue, 10 February 2009 05:18 Go to next message
raghu.iv85
Messages: 13
Registered: December 2008
Location: banglore
Junior Member
Hi All,


I want to know the main usage of Materialized views. When we need to use these mviews ?
Re: Materialized views [message #385633 is a reply to message #385625] Tue, 10 February 2009 05:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This has nothing to do in Unix forum.
All documentation, including one about replication, can be found at http://tahiti.oracle.com

Regards
Michel
Re: Materialized view [message #385649 is a reply to message #385625] Tue, 10 February 2009 06:53 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
I am sure that you will, of course. have read the documentation on Materialized before asking the question. Why don't you start by telling us what you think they are best used for.
Re: Materialized views [message #385676 is a reply to message #385625] Tue, 10 February 2009 08:55 Go to previous message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>I want to know the main usage of Materialized views. When we need to use these mviews ?
You are not REQUIRED to use Materialized views.
Previous Topic: ON DELETE CASCADE and ON UPDATE CASCADE
Next Topic: update records using cursor (merged 3)
Goto Forum:
  


Current Time: Tue Dec 06 10:04:34 CST 2016

Total time taken to generate the page: 0.07788 seconds