Description

A database object that contains the results of a query. It may be a local copy of data located remotely, or may be a subset of the rows and/or columns of a table or join result, or may be a summary based on an aggregation of a table's data.

Where to use

• Complex reporting queries.
\n
• Improving read performance.

Real World Example

Instead of joining 5 tables every time to show the 'Daily Sales Dashboard', a background job runs every hour and saves the result to a 'DailySales' table (view).

Code Example

class MaterializedViews:
    def __init__(self):
        pass

    def execute(self):
        print('Executing Materialized Views')