Index on materialized views

Add an index to a materialized view.

Index on materialized view

You can create an index on a materialized view with CREATE INDEX. It speeds up queries.

CREATE INDEX idx_mv_date ON daily_revenue (sale_date);

This query adds an index on the date column.

The index idx_mv_date is created.

Since a materialized view is like a table, you can add indexes. Queries get noticeably faster.

For example, adding CREATE INDEX on sale_date lets a report that asks for a specific date find it without scanning every row.

Add a sale_date index on the daily_revenue materialized view.

Show example solution

CREATE INDEX idx_mv_date ON daily_revenue (sale_date);

Add CREATE INDEX

CREATE ____ idx_mv_date ON daily_revenue (sale_date);

Show answer

CREATE INDEX idx_mv_date ON daily_revenue (sale_date);