Updatable views
Materialized views
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.
