|
Re: Materialised Views [message #9698 is a reply to message #9696] |
Tue, 02 December 2003 02:14 |
Daljit Singh
Messages: 290 Registered: October 2003 Location: Texas
|
Senior Member |
|
|
Hi,
Well materialized view are the types of views which contain data means data is actually physically store in diff place and the view is also based on some table/tables.
This concept is heavily used in data warehousing system, we can set diff option regarding how to refresh the data in Mview or u can create a static mview as well. We can specify the time schedule according to which mview get refreshed from the base table/s. Mainly there r two types of refreshes available one is complete and another is fast. In complete all the data in mview get truncated first and then inserted from the base table/s and in complete only changed data in base table/s get reflected in mview. This get possible due to the use of log tables which exists which the base table/s and store all the changed applied to the base table/s.
For complete syntax and indepth detail refer oracle doc.
|
|
|