Materialized query tables

A materialized query table is a table that caches the results of a query. When you submit the query again, the database engine can return the data from the materialized query table. You can use materialized query tables with nicknames to improve the performance of a query.

Materialized query tables are used when you create a cache table. The cache table stores local data that is defined by the materialized query tables that are associated with it.