# Stored and Materialized Views in Databricks

## What Are Stored Views and Materialized Views?

### Stored Views

> A **stored view** is a virtual table that does not store data. Instead, it saves an SQL query, which dynamically fetches data from underlying tables or other views every time it is queried.

* It provides a simplified and reusable way to represent complex SQL queries.
    

### Materialized Views

> A **materialized view** stores the results of a query physically, allowing faster access to precomputed data for repeated queries.

* Materialized views need to be refreshed to reflect updates in the underlying tables.
    

*The rest of the blog can be read using this link:* [Stored and Materialized Views in Databricks](https://www.linkedin.com/pulse/stored-materialized-views-databricks-naveen-pn--cwonc/)