Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Materialized View

A materialized view should be thought of as a special kind of view, which physically exists inside the database. It can contain joins and/or aggregates and exists to improve query execution time by pre-calculating expensive joins and aggregation operations prior to execution.