Views vs. Materialized Views

Difficulty: Advanced

Question

Difference between a View and a Materialized View?

Answer

A **View** is a virtual table that runs its query every time it is accessed. A **Materialized View** pre-computes and stores the result physically, requiring periodic refreshes.

Concepts covered

Virtual Table, Caching, Performance