Materialized views can be used to cache the results from queries that would normally be very demanding on a database. This is much different than a regular view which doesn’t actually store any data. A regular view only stores a query that will be executed against the base table, while a materialized view will actually store the results from a query that was executed on the base table. Once the materialized is created, the data can be refreshed in two ways: complete or fast. In this blog, I will discuss the use of a complete refresh, and I will discuss the use of a fast refresh in the next blog.
Viewing entries tagged