| VIEWS and materialized views [message #351440] |
Tue, 30 September 2008 19:49  |
dbareddy
Messages: 7
Registered: August 2008
|
Junior Member |
|
|
Hi,
I read many books,forums, but i could not find the MAIN difference between a VIEW and a MATERIALIZED view. Can any one please help to understand.
I know that,
- a VIEW is a customised representation of data of one or more tables, and which is same as with MATERILAZED view.
- VIEW occupies space, where M.View doesnot occupy.
- VIEW actually doesn't contain data, it contains.
But, i could not understand the MAIN difference, why we use M.VIEW, if it is same as VIEW.
I'm sure that i am wrong, can anybody please help me out.
Thanks in advance.
|
|
|
|
|
|
| Re: VIEWS and materialized views [message #360036 is a reply to message #351440] |
Wed, 19 November 2008 05:28  |
vijaychauhan
Messages: 106
Registered: December 2005
|
Senior Member |
|
|
hi!
View does not store any data and it does not occupy any space, it pulls the data from base tables on which it is bulit, at the time when it is called, it will not be a segement in database.
where as Mview occupies space and stores the data, it is also bulit on a table, from which it takes data, also the data in mview generally gets refreshed from the base table. The mview is a segment. it is generally used as a summary table or to store data from multiple tables in a data warehouse, where the result will be faster as compared to a table. Where as view is generally used when you want to provide access to only particular columns of a table and view can be read only.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
