Materialized View
M
Materialized View
Definition
A database object that stores the precomputed results of a query physically on disk, unlike a regular view which re-executes the query each time. Materialized views improve performance for complex aggregations and joins, but require periodic refreshing to reflect data changes.