Materialized View

Precomputing monthly revenue totals.

Synonyms:

Precomputed query result, Cached query table

Defnition:
A materialized view stores precomputed query results for faster analytics on complex aggregations.

Variations:
Materialized query view