What is a VIEW?

Question

What is a VIEW?

Accepted Answer

A view is just a named SELECT statement - no data is stored unless you use a materialized view. Every time you query a regular view, the database runs the underlying SELECT fresh. Views are useful for hiding complexity, restricting column access, or giving a stable interface to a table whose schema may change.