Database Management Systems · Query languages

Views and materialized views

A saved query that acts like a table; materialized means the result is actually stored, not recomputed each time.

Also known as: views, materialized views.

Start a lesson on Views and materialized views

Learn first

• SQL subqueries: A query nested inside another query, used as a stand-in value or filter.

Related topics

• Data warehousing and OLAP: A separate database optimized for big analytical queries over historical data, not fast day-to-day transactions.