seniorSQL

What is a materialized view refresh strategy?

Updated May 17, 2026

Short answer

Materialized view refresh strategy defines how and when precomputed query results are updated.

Deep explanation

Materialized views store the physical result of a query. Since underlying data changes, the view must be refreshed. Strategies include FULL refresh (recompute everything), FAST refresh (incremental updates using logs), and ON COMMIT or ON DEMAND refresh. The choice depends on freshness requirements vs performance cost. Fast refresh requires materialized view logs and is more complex but efficient for large datasets.

Unlock with a Pro subscription to view this section.

View pricing

Real-world example

No real-world example available yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

Common mistakes

No common mistakes listed yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

Follow-up questions

No follow-up questions available yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

More SQL interview questions

View all →