Question: what is the difference between table and materialized view?
Answer: Basically views are exist logically unlike tables. ... 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.