Loading subject…
Database view
A named SELECT statement stored in the database and queried like a table, returning data drawn from one or more base tables.
Materialized view
A view whose result rows are stored physically in the database and refreshed periodically, so reads are fast but the data is only as current as the last refresh. Also called a snapshot view.