I've being using Oracle for about 10 years, I never realized there is something called Materialized Views until I chat with my supervisor today.
So, what is Materialized Views?
From the help center: A materialized view is a database object that contains the results of a query. The FROM clause of the query can name tables, views, and other materialized views. Collectively these objects are called master tables (a replication term) or detail tables (a data warehousing term). This reference uses "master tables" for consistency. The databases containing the master tables are called the master databases.
In my understanding, it's a just a snapshot at the time people run the query statement.
I also noticed other item called…