A materialized view is a table with data that is automatically inserted and updated from another base table. The materialized view has a primary key that differs from the base table, so that different queries can be implemented.