Materialized views

- [Instructor] Materialized views combine … some of the features of tables and views. … Materialized views are used to store … the results of pre-compute queries. … For example, we may have to perform an expensive join … and we want to minimize the number of times … we actually need to run that query. … By materializing or storing the results of the query, … we can use those stored results for other operations … without performing the expensive query again. … While materialized views can save time, … they will take up space. … Materialized views duplicate data … that is already stored in tables. … Data in materialized views can be stale. … You have to update or refresh materialized views … to capture changes to the source tables … that made up the materialized view. … Another thing to keep in mind … is that there is the potential for inconsistencies … between source tables and materialized views. … If you can tolerate these potential problems, … the materialized views may help you reduce …