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
4. Querying materialized views – 1
Summary

Instruction

Perfect! As we said before, when you create a materialized view, the underlying query is computed and the resulting rows are physically stored in the database. This gives us quicker access to the data in the view. We can query a materialized view just like a standard view:

SELECT
  rank,
  city,
  name
FROM top100_universities
ORDER BY rank;

Nothing strange here!

Exercise

Select all the information from the available_dairy_products view you've just created.

Compare the results with the data in the underlying table. As you can see, the data is up to date.