What is the difference between Views and Materialized Views in Oracle?

sql oracle view relational-database materialized-views
juan picture juan · Sep 18, 2008 · Viewed 676.1k times · Source

What is the difference between Views and Materialized Views in Oracle?

Answer

dacracot picture dacracot · Sep 18, 2008

Materialized views are disk based and are updated periodically based upon the query definition.

Views are virtual only and run the query definition each time they are accessed.

Related questions

How to view the original script of a materialized view?

I am interested in moving a materialized view from one db to the other, regardless, I also need to change one of the columns. How can I view the original script that build the MV? I am running TOAD, but …

Read More
Query on View is running slower than direct query - in Oracle

I tried creating view with parameters to get the data dynamically. (I cant use WHERE condition as the select statement itself changes based on the parameters) For this, I wrote a procedure which returns me the required data as oracle …

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More