A virtual table that lets you treat a SELECT statement's result as if it were a table.
A virtual table that saves a SELECT statement under a name, letting it be referenced as if it were a table. The underlying data isn't duplicated. Unlike a regular view, which re-runs its SELECT every time it's queried, there's also a materialized view, which physically stores the result ahead of time -- used to speed up queries with heavy aggregation.
© 2026 ITBGM