Introduction


In a previous article, I explained the difference between tables and views, using the analogy of a diner’s refrigerator and menu. As a follow-up, this article focuses on the types of views in SQL.

Broadly speaking, there are two types of views:


Regular Views (View)
Materialized Views (Materialized View)


A regular view is...