What is the Difference between a View and a Materialized View?

A view takes the output of a query and makes it appear like a virtual table; and it can be used in place of tables.


A materialized view provides indirect access to table data by storing the results of a query in a separate schema object.