A materialized view is a database object that stores the pre-calculated result of a query, instead of running that query again every time it is needed.
In this video we show how a materialized view differs from a regular view, and why it is so useful for speeding up complex, frequently-repeated queries.
We go through the syntax for creating and refreshing a materialized view — including exclusive and concurrent refresh — and then walk through a hands-on example that calculates product stock balance.
The result: a real performance comparison where the same query runs up to 95 times faster.
Watch now and see how materialized views can speed up your database.