In Databricks SQL, what is the key difference between a standard view and a materialized view?

Question

Accepted Answer

B. A materialized view stores pre-computed query results physically; a standard view computes results at query execution time. A standard (regular) view is a named query that executes against the underlying tables each time it is queried. A materialized view pre-computes and stores the query results physically, so queries against it read from the stored results rather than re-executing the query. This distinction is a core data modeling concept in Databricks SQL. Options A, C, and D each misstate the properties of one or both view types.

In Databricks SQL, what is the key difference between a standard view and a materialized view?

Related Questions

Discussion