Is Materialized View a Table?

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).

What is the difference between materialized view and table?

Materialized views are physically exist in database. Whenever the base table is updated the Materialized view gets updated. Materialized views are updated periodically based upon the query definition, table can not do this. A materialized view can be set up to refresh automatically on a periodic basis.

What materialized table?

A materialized query table (MQT) is a table whose definition is based upon the result of a query. The data that is contained in an MQT is derived from one or more tables on which the materialized query table definition is based.