True or False: You can cluster materialized views just like tables?

• A. True
• B. False
• C. Not Applicable
• D. Depends on the view

Answer: (A)

Clustering keys organize how data is laid out on disk, so pruning can skip large chunks of data during queries. Materialized views store a physical result set, just like tables, and you can apply clustering to them. By defining a clustering key on a materialized view, Snowflake maintains the data in those clustered partitions as the MV is refreshed, which improves query performance for filters on the clustering columns. This is why you can cluster materialized views just like tables. Ordinary views don’t store data, so clustering doesn’t apply to them.