ADA-C02: SnowPro Advanced — Administrator

By Snowflake · Question Mode

QuestionQ35

VerifiedPerform database monitoring, tuning, and optimization

If a query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?

Explanation

Materialized-view query rewrite is discretionary: Snowflake’s optimizer can choose the base table when it estimates equivalent or better performance, such as when clustering enables effective micro-partition pruning. A matching materialized view is therefore eligible for rewrite but is not guaranteed to be used.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!