Materialized View

A view whose results are physically stored on disk and must be explicitly refreshed. Useful for caching expensive query results. Unlike regular views, materialized views can be indexed.