Skip to main content

Views and Materialized Views

Learn Views and Materialized Views (Design and Database Objects, PostgreSQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

A view is a saved query that looks like a table. A materialized view also stores the result, so it is fast but must be refreshed.

More lessons in Design and Database Objects