A materialized query table is a database table that provides precomputed result sets for specified queries, which speeds access to selected data from the larger source tables against which it runs.
You can perform the following tasks with materialized query tables: