thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Materialized View

A database object that stores the precomputed result of a query and refreshes it as base data changes.

Definition

Materialized views trade storage and maintenance cost for faster reads of expensive aggregations. Refresh can be automatic (Snowflake, BigQuery), on commit or on demand (Oracle), or handled through indexed views in SQL Server. Snowflake materialized views can query only a single table and require Enterprise Edition.

Example

CREATE MATERIALIZED VIEW mv_daily_sales AS SELECT sale_date, SUM(amount) FROM sales GROUP BY sale_date;

Exam tip

Snowflake materialized views cannot contain joins; for multi-table, pipeline-style transformations use Dynamic Tables.

Related terms