Materialized Views

[mallard]

What are materialized views?

[ales]

One of the best explanations could be found here:

http://otn.oracle.com/docs/products/...chem.htm#18094

[jasontang]

materialized view is a kind of instantial view, the data of materialized view is stored in the database,so the performance is improved. it is also called snapshot.

it is different from the normal view. oracle does not store any data for normal view,it only stores the SQL statement of the view in the database.

[mrvajrala]

I bet you Have to read the manual or some document on Materialized Viewes..

Basically The term Materialized views is a synonym for Snapshots. They are very much useful for perfromance.

Like , if you have query fired hundred times a day and every times it will fetch the data from the base tables, its time consuming and performance hit.

What if i have got stored data for a "query" that i am using hundread times a day... think ... that is nothing but materialized view... And i am going to get very good performance .

This is usually used in replicated environments...

Thanks,
Madhu