Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Working with Views

Updatable views
Materialized views
5. Querying materialized views – 2
Summary

Instruction

Good! With a materialized view, we get quicker access to the view data – the query is not run over and over again. However, what happens when we change some data in the underlying table? Let's find out.

Exercise

Run the template query. It adds a new item into the product table and then queries the materialized view.

As you can see, the new row is not visible in the materialized view.