What are database views? Differentiate between regular views and materialized views.

Answer preview

A view is a named, stored SELECT — a virtual table with no data of its own; every query against it re-runs the underlying SQL. A materialized view stores the computed result on disk, so reads are fast but the data is a snapshot that must be refreshed.…