Summary - Materialized view

Speed up a heavy report with a materialized view.

Summary - Materialized view

A materialized view physically stores the result. Created with CREATE, updated with REFRESH.

CREATE MATERIALIZED VIEW sales_summary AS
SELECT category, SUM(amount) FROM sales GROUP BY category;

Summary mat view.

The materialized view sales_summary is created. category, SUM(amount) is selected from sales. Rows are grouped by category; aggregate functions are computed per group.

Exercise Summary - Materialized view

Summary: create the sales_summary materialized view.

Show example solution

CREATE MATERIALIZED VIEW sales_summary AS
SELECT category, SUM(amount) AS total
FROM sales GROUP BY category;

Test yourself

What updates a materialized view?
- COMMIT
- ALTER
- REFRESH
- DROP
Show answer

REFRESH — It is updated with REFRESH.
Summary - Materialized view: match the terms

materialized

physical
REFRESH

update
index

speeds up
view

virtual

Next lesson: What is a procedure?

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies