Materialized Views

Overview

Materialized Views (MVs) improve the performance of repeated, complex queries by pre-computing and storing the query results as physical data. This is different from standard views, which execute their underlying SQL every time they are queried.

Key Concepts

What is a Materialized View?

A Materialized View is a view whose results have been computed and stored as a physical table.