What is A MVIEW?

[djhex]

Can somebody please explain me what a Materialized View is? I ve never heard of it. thanks

[stecal]

The answer to this question, and many of the other questions you have posted, can be found at http://tahiti.oracle.com. Pick a version, do a search. Really, it's pretty easy to do.

[balajiyes]

http://www.engin.umich.edu/caen/wls/software/oracle/server.901/a90237/mv.htm

Cheers!

[stecal]

Great, so now we're relying on U of Mich for documentation? Why stop there when there are hundreds of other places that have posted Oracle docs on their websites? It would have been more useful to tell djhex to install the documentation locally or go buy a friggin' book and look it up for himself. Which, by the way djhex, why don't you go buy a friggin' book and look this up for yourself?

[patel_dil]

A Materialized View is like a snapshot of your data derived from other table(s). Its just like a table whose data comes from other tables/views.

Generally materialized views are used in data warehousing environment where they can be of great help for performance gains. You have to explicitly refresh the data in MV regularly based on your requirements.

read http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76994/mv.htm

[Veen]

MViews can also be used in Replication environment as like Snapshots in a distributed environment .